Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Formatting for Thousands & Millions

Hi all,   I wonder if anyone can suggest a means of using the custom format capabilities of PowerBI to replicate what in Excel would look like this:   [>=1000000] #,##0.00,,"m";[<1000000] #,##0.0...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Refer

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

https://community.powerbi.com/t5/Desktop/Measures-editing-number-formats/td-p/240597

 

 

Measure = FORMAT( sales[sales], $#,##0;($#,##0) )

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    Thanks for the reply - I think maybe you misunderstood the question slightly: I'm looking to use custom formatting in the Model view to do this rather than in a measure. The ultimate goal being that I can do a quick, non-destructive change to a number's format rather than having to go a write a measure everytime (as per the SWITCH suggestion in my original post). The RADACAD article is useful, but only really for date formats.

     

    Custom format in Model view

     

    Thanks,

     

    SamB