Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Measure format: Currency + auto decimal?

I have several cards displaying measures like SUM(sales) and their value can range from billions (unfiltered) to millions after filtering.

 

When the decimal point is set to auto, it automatically adjusts the value from say 1.52bn to 582M i.e. 2 decimal places when in billions and none when in millions. Perfect.

 

However, when I switch to using a currency format the auto decimal point is unavailable and so it must always have a fixed number of decimal places. 
If I set it to 0dp then I will get 2bn overall which is not what I want. If I set it to 2dp then I will have 582.54M when it's filtered which is equally not what I want.

 

Is there any way to specify a currency and still have automatic decimal places in Power BI Measures?

 

p.s. I've tried conditionally rounding the value to 0 dp when it is less than a billion but it still managed to display two decimal places. Cheeky Power BI remembering decimal places I think.

 

Thanks

  • Hi Anonymous,

     

    Based on my test, if we use Currency General format, the auto decimal point option will be still available. Could you go to check if it works in your scenario? :smileyhappy:

     

     

    Regards

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    Hi Anonymous,

     

    Based on my test, if we use Currency General format, the auto decimal point option will be still available. Could you go to check if it works in your scenario? :smileyhappy:

     

     

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable

       

      It works! Thank you very much, I kept clicking the dollar sign and didn't look for a general currency. Lesson learnt

      • Anonymous's avatar
        Anonymous
        Not applicable

        How to you make it as 1.6 MMM format? and M to MM and K to M format?