Power BI Feb 2024 Update: Visual Calculations Walkthrough!

Power BI Feb 2024 Update: Visual Calculations Walkthrough! Join us on an exciting exploration of the latest advancements in Power BI with our in-depth walkthrough of the Feb 2024 update's new visual calculations. In this tutorial, we delve into each new visual calculation introduced in the update, providing comprehensive explanations and practical demonstrations to help you grasp these features effectively. Learn how to harness the potential of visual calculations to elevate your data analysis and visualization capabilities in Power BI. Follow along with clear step-by-step instructions, real-world examples, and expert insights to master the new functionalities introduced in the update. Whether you're a novice or an experienced user, this walkthrough empowers you to unlock the full potential of Power BI's Feb 2024 update and enhance your productivity and insights. Embark on this educational journey with us to stay ahead of the curve and maximize your data analysis prowess in Power BI!
Follow along using the same file!
PBI - 20240219 - Feb 2024 Update - Visual Calcs.pbix
github.com/powerbibro/powerbibro
Microsoft DAX Format Function
learn.microsoft.com/en-us/dax...
Timestamps:
0:00 - Introduction Feb 2024 Update
0:46 - Matrix Overview and Preview Feature
3:52 - Running Sum
5:50 - Moving Average
6:50 - Percent of Parent
8:25 - Percent of Grand Total
9:33 - Average of Children
10:34 - Versus Previous
11:05 - Versus Next
11:55 - Versus First
12:45 - Versus Last
#powerbi #powerbidesktop #powerbibro #powerbitutorial
#datavisualization #dataanalytics #businessintelligence #microsoftfabric

[@beingrishi6450]

Excellent Update so far alongwith Dynamic subscription

[@PowerBIBro]

Thank you for all your support!

[@beingrishi6450]

Great Explanation, cleared the concept

[@PowerBIBro]

Thank you glad it is helpful!

[@CathLauLifts]

Wow, thanks for getting a video out on this so quickly!

[@PowerBIBro]

My pleasure!!

[@unnikrishnansanthosh]

clear-cut explanation, thank you for sharing

[@PowerBIBro]

Thank you!!

[@montassarbellahjaaouane8291]

Thanks

[@PowerBIBro]

My pleasure and thanks for your support!!

[@SmartBimson]

Really 🎉cool Video ! Very informative 👍🏻

[@PowerBIBro]

Glad you liked it!

[@user-hf9js8fh4l]

Excellent video!!!!, just subscribed

[@PowerBIBro]

Awesome and thank you!!

[@SnkRobertoHz]

Amazing! Excellent video. You just got one subscriptor. More videos with visual content please! Many thanks

[@PowerBIBro]

Awesome and thank you!!!

[@Spotlight.Data.Analytics]

Nice explanation. Thanks!

[@PowerBIBro]

Excellent thank you!!

[@creandoyblogueando]

Great presentation!!!

[@PowerBIBro]

Thank you very much!

[@dutchdatadude]

Thanks for sharing, hope you like it!

[@rn4341]

Hey, I'm trying that formatting function for my running sum. It works well when doing it on a table visual, but when switching to a line chart, the line on my visual disappears and only comes back when I remove the FORMAT function right before my Runningsum. Any help on this?

[@PowerBIBro]

Thanks for the question! The format function converts the value to a user friendly value, but it removes the numerical properties (which are needed for the line chart). You can also create two calculations, one with the format and another without. Then use the non formatted for the line, and the other for the tooltips etc..

[@rn4341]

@@PowerBIBro it does show as a value on the line chart, ( e.g 620,829.00 or 0.6M) that works fine,
But when formatting to currency, the line disappears.

[@PowerBIBro]

@rn4341 what if you try creating a 2nd measure that is formatted as currency, using it only on the tooltip or data label? This way the line will display, but the label and tooltip will have the $ currency format

[@decentmendreams]

It looks like what InfoRiver has been doing .

[@PowerBIBro]

Thanks for sharing, will check it out!