Forum Discussion
Different number formats
MagubaneSSP Here is a percent, whole number and decimal format:
Measure 2 = VAR __Value = SUM('Table'[Column2]) RETURN SWITCH(MAX('Table'[Column1]), "one",FORMAT(__Value,"Percent"), "two",FORMAT(__Value,"##"), "three",FORMAT(__Value,"00.00") )
Community ChampionMagubaneSSP Yeah, the way you have it setup now you would have to use FORMAT strings to format it depending upon the situation. For the rest of it, hard to know for sure. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg_Deckler
Thank you for your considered response, could you please share the format string to show different formats in one visual?
I have been able to solve the other issue using the SUM function - but the visual is still not correct becuase of the different number formats.
Thank you!
- Greg_Deckler
MagubaneSSP Here is a percent, whole number and decimal format:
Measure 2 = VAR __Value = SUM('Table'[Column2]) RETURN SWITCH(MAX('Table'[Column1]), "one",FORMAT(__Value,"Percent"), "two",FORMAT(__Value,"##"), "three",FORMAT(__Value,"00.00") )