Forum Discussion

RafalK's avatar
RafalK
Advocate IV
6 years ago

Dynamic formatting of measures - tutorial

Hi everyone - I would like to share how to use dynamic formatting on measures in Power BI. This has already been available by using FORMAT DAX function, however that function converts measures to te...
Show and Tell
Tips and Tricks
TaraB89's avatar
TaraB89
Helper II
5 years ago

Hello, Thank you for the guide, it helped me with a visual where I was using a Dynamic Measure.

But....

It seems to have an effect on a lot of other visuals as well. Some measures suddenly take a different format then what I set it to.

Those are measures that have nothing to do with the ones I made it for. Sorting options dont work properly anymore because of it.

When I remove the Dynamic Formating table, it goes back to normal.

 

Simple example, I have a different measure that is a Percentage, but as a Gauge it simply won't show it as a percentage. In a matrix or table, it shows it as percentage, but not as a gauge.

 

How do i make it so that the Dynamic Formatting only works for the Dynamic Measure?

  • RafalK's avatar
    RafalK
    Advocate IV
    5 years ago

    Hi - yea there are some problems with the method. 

    For 1 it works best if you have just one measure on the visual. If you add more they will all be formated.

    As for your Gauge I'm not sure wht it is the case. Perpaps the format you are using is not the same "percentage" format as the visual requires? All I can suggest here is to use the original measure without the dynamic format option.

    • TaraB89's avatar
      TaraB89
      Helper II
      5 years ago

      Hi thanks for the reply.

       

      Oh well it still helps knowing there is a work around 🙂 

      Hope they will add something in the future so you can use FORMAT and that it wont be text or something

      Thanks for the guide!