Forum Discussion
Solved
Different number formats
Hi Power Bi Experts, I am struggling with displaying numbers in different formats on a power bi visualize or matrix. Simply put, I want to be able to show percentages and whole numbers in one vis...
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") )
Greg_Deckler
Community Champion
Community ChampionMagubaneSSP 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")
)