Multiply number formatting number in column

[Syndicate_Admin]

Hello community

i have a column in a matrix table with porcentage and decimal values. How can display the correct formatting for each value? What I need is to show the numbers in porcentage and in decimals depending of the value. However power bi shows all the values in a single format, decimals or porcentage. Is there a way to respect the formatting for each value?

thank you

[ribisht17]

@Syndicate_Admin 

Please mark the answer if it helped you so that it can help others as well

Regards,

Ritesh

[ribisht17 · Accepted solution]

@Syndicate_Admin 

This is solved here Solved: Different number formats - Microsoft Power BI Community

Measure 2 = 
    VAR __Value = SUM('Table'[Column2])
RETURN
    SWITCH(MAX('Table'[Column1]),
        "one",FORMAT(__Value,"Percent"),
        "two",FORMAT(__Value,"##"),
        "three",FORMAT(__Value,"00.00")
    )

Thanks,

Ritesh

[Anonymous]

i did not understand , please explain detailed