Visual Calculations in Power BI

⚡⚡⚡More information in the description below⚡⚡⚡
A first look at Visual Level Calculations in the February 2024 release of Power BI Desktop. Looks very promising, should simplify a lot of common DAX requirements.

⚠️ Formatting Update:
There's new formatting options as of August 2024

If you need to do further calculations on a field AND you want to display it formatted then you will need to create a duplicate unformatted column and hide the original non formatted column that is used in further calculations.

At this stage you also cannot sort by a measure value (the RUNNINGSUM doesn't respect the sort order of a visual if it's sorted by a measure) Instead you'd need to do something like this
RUNNING TOTAL by Units= SUMX(WINDOW(1, ABS, 0, REL, ROWS, ORDERBY([Units], ASC)), [Units])

Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

[AccessAnalytic]

⚠️ Formatting Update:
There's new formatting options as of August 2024

[FredericLEGUEN-Excel]

The Microsoft engineers have understood that DAX is not easy to learn and to understand. Finaly, they have simplify the way to build your measure (that's a good point) 👍

[dutchdatadude]

Surprise! Awesome video! And yes, the format thing you mentioned is a limitation, for now. There are many more that we will have in our docs and will work on as we progress.

[sanchowitfurrows]

it is unbielivable, I am looking for a proper percent per category measure for a few days and checked your channlel just to distract a bit and here you show me solution! Thank you!

[PSModelling]

Perfect, great to see Power BI gradually becoming more user friendly as it's not the easiest thing to pick up.

[alano]

@accessanalytics There is a formatting option, not for the new calculation, but for the visual itself. Just add your new calculation. Then select your visual and select Format Visual | Gereral | Data Format | Apply Settings To and and then select you calculation name and there is a formatting option there

[analyst]

Wow, thanks for sharing, Wyn! This is an awesome addition. I really look forward to using this in my own work. I think it will make PBI development much faster in certain situations.

[zvikabar-kochva]

Great feature. It looks like Power BI is going the way of Tableau. This feature is will make PBI much easier to use, but, it will need lots of improvements before it will acquire Tableau's level of calculation options.

[arbazahmad]

Excellent update 👏.. .... Dax become easy with this new updates...

[arduiscane]

Great video, great enthusiasm. I was looking for something that would walk me through what this is all about and you did great. I was playing with this earlier to try and add calcs to visuals where i built outright measures to solve one calc for one place and this hits the spot. So many single use measures in my model adding so much confusion

[roverre]

Thanks a lot Wyn i'm always enjoy your way to share, with an incredible passion what you discovery, your knowledge, in such nice "simple" and awesome style..!!! :)

[smanzoli]

How does it differ from QUICK MEASURES we already had in Power BI???

[joaorataoo]

It certainly makes DAX simpler, but does it make development better?
We mustn't forget that one of the crucial and wonderful aspects of DAX is that the measures aren't tied to a specific context.

[huwdavis]

This is a great little video, but assumes that you have the feature available. Probably best not to assume that everyone has Preview Features set to allow this function to appear.

[clairejsquibb]

Like the Add/Remove Decimal icons in Excel, I'm sure those row/column arrows are going to cause no end of confusion!

[barttitulaerexcelbart]

Thanks Wyn, I think this will make live easier for a start.

[Simon-vcwk]

Is it not a risk using preview features in live reporting for an Organisation? Just incase there is a bug from MS or they pull the feature. Preview features take considerable time to hit the live version of pbi but there is no way for admin to switch them off from a user perspective hitting the tenant. Just a thought

[coollehavre]

thanks for this post its great but....this measures exists only in visuals like implicit measures...that is à bad practice.... what do you think about that ?

[tiruveedipradeepkumar]

Very Nice...Good Information...Thank you so much....

[zzota]

That's a really useful feature. Thanks for sharing.