#powerbi #video about the dynamic formatting feature that is most recently introduced

[parry2k]

Hello friends! It is nice to be back and finally had a chance to share this #powerbi #video about the dynamic formatting feature that is most recently introduced in the #powerbi April 2023 update.

One of the key benefits of dynamic formatting is its ability to enhance the readability and visual appeal of data presentations. For instance, by switching to a billion value format, data that would otherwise be displayed as large numbers can be made more easily understandable to viewers. The video provides the solution on how to switch between value formats, such as thousands, millions, and billions, to suit the specific data being analyzed.

Additionally, it provides tips and tricks for leveraging dynamic formatting and a deeper understanding of how to use dynamic formatting to enhance data visualizations.

Enjoy and share, and leave your valuable and constructive feedback.  https://youtu.be/tTNkPesnx5M

Make sure to hit the subscribe button to stay up to date with the upcoming videos on Power BI - youtube.com/@PowerBIHowTo

[parry2k]

@johnt75 very nice. thanks for the update. I was not aware that you can refer to the measure back in the format string. This is awesome. 

[johnt75]

Good video as always. There are a couple of points I'd make.

Within the format string expression you can refer to the base measure, so you don't need to worry about creating a hidden measure or maintaining the same code in 2 different places. So if your base measure is 

Sum of col2 = SUM( 'Table'[Column2] )

then in the format string expression you can use

VAR CurrentValue = [Sum of col2]
RETURN SWITCH(
    TRUE(),
    CurrentValue <= 1, "£#0,0.00",
    CurrentValue <= 2, "$#0,0.00",
    "0"
)

The other thing I think is important, and very good, is that whether you use the measure reference or you duplicate the code inside the format string expression, it seems to only be executed once. Looking at the storage engine queries which are created there is only 1 instance of the query needed for the calculation. I can't tell much about the formula engine as I am not good at reading the query plans, but I would imagine that it is also using the cached result. So this means that we are not going to take a hit on performance for using the value of the measure within the format string expression, which is great. I do wonder though if MS will release a new function like SELECTEDMEASUREVALUE() to allow us easier access to it.