Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need help with formatting numbers in Power BI. The default is to represent thousands with K and millions with M. My company uses M to represent thousands and MM for millions. So 104,000 would show 104M and 1,400,000 would be 1.4MM. Is there a way to change these settings or create a measure to format the numbers like this?
Solved! Go to Solution.
Hi @Anonymous ,
Please try this:
Result = SWITCH(TRUE(), Tablename[Columnnane] < 1000, concatenate ("$", Tablename[Columnname]), Tablename[Columnname]>=1000, concatenate ("$", concatenate (
(Tablename[Columnnane]/1000, "M")), Tablename[Columnname]>=1000000, Concatenate ("$", concatenate (Tablename[Columnname]/1000000,"MM"))
@Anonymous -> please hit the thumbs up and mark it as a solution if it helps you. Thanks.
I also need to do this to my reports and have dozens of measures that need this formatting applied. Is there no way to add a GLOBAL format to Power BI so that I can simply choose the global format from the menu (the way I choose Currency or Percent formatting?)
Great Answer
I am more looking for settings. I have a lot of different measures that involved these numbers so would be tough to try to do this for every single measure or aggregate function. Also, this would mean the numbers in any visuals would still have the K or M rather than M or MM
Hi @Anonymous ,
Please try this:
Result = SWITCH(TRUE(), Tablename[Columnnane] < 1000, concatenate ("$", Tablename[Columnname]), Tablename[Columnname]>=1000, concatenate ("$", concatenate (
(Tablename[Columnnane]/1000, "M")), Tablename[Columnname]>=1000000, Concatenate ("$", concatenate (Tablename[Columnname]/1000000,"MM"))
@Anonymous -> please hit the thumbs up and mark it as a solution if it helps you. Thanks.
Hello, I tried it and it didnt work, would you be able to guide me in more details since I am a beginner on Power BI. this done through measure?
Thanks,
User | Count |
---|---|
99 | |
90 | |
83 | |
72 | |
66 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |