Dynamic formatting of measures - Power BI Desktop Update - August 2020

[RafalK]

Hi everyone,

Looks like there is an option to dynamically format measures without the need to use FORMAT function.

It has been presented on the youtube Power BI update video. On eneeds to use Tabular Editor to do it.

My question is - has anyone been able to do that?

I have the exact same version of Tabular Editor on my machine but there is no option for "Format String Expression" - Only "Format String" next to my measures.

Video:

My model :

[RafalK · Accepted solution]

Got it!

I have made a tutorial on how to create a dynamic formatting for measures.

https://community.powerbi.com/t5/Desktop/Dynamic-formatting-of-measures/m-p/1297373#M565099

[parry2k]

@RafalK as mentioned earlier, it was going to work with calculation groups. Anyhow, good you put a blog post on it but honest opinion, your blog post is a bit hard to follow (I could be wrong) especially who never used this before, you should highlight the areas in the post and also try to keep different names, too many places "dynamic" word is used. Just my 2 cent.

[RafalK]

@parry2k thanks for the feedback. I did change the flow of the tutorial so now it should be a little easier to understand.

[RafalK]

Looks like this is only an option for Calculation Groups so I'm not usre if thos will help me.

I have a column with measure name, measure for each name and a measure with SWITCH.

Once I select "Sales USD" in column my SWITCH measure will return Sales USD value. If I select Sales Volume it will return Sales Volume value itc.

Now - I need this measure to have different formatting based on what measure name has been selected.

Is it possible to do with the new String Format Expression and Dynamic Groups somehow?

[parry2k]

@RafalK did you added a calculation group and trying to add expression for an item?

[amitchandak]

@RafalK , I Checked the video in Guyinacube show that but that is version 2.9.8

I am having 2.11.6 and see the same option as you, Try giving format string and check

There is one video from Guyinacube - But steps are same -https://www.youtube.com/watch?v=vlnx7QUVYME

[camargos88]

Hi @RafalK ,

Maybe this link can help you:

https://radacad.com/custom-format-fields-and-measures-in-power-bi