Forum Discussion

MagubaneSSP's avatar
MagubaneSSP
Frequent Visitor
4 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    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")
    )
MagubaneSSP's avatar
MagubaneSSP
Frequent Visitor
4 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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")
    )
  • MagubaneSSP's avatar
    MagubaneSSP
    Frequent Visitor
    4 years ago

    Hi Greg_Deckler ,

     

    Thank you so much - this works perfectly, for now!