Format a number calculated column in Matrix Viz

[TK1966]

Thanks in advance!

I have created a matrix visualization and my primary column is sum of hours. I then created a calculated column (Optimum) to run alongside it, BUT how do i then format that  optimum column to become a % value rather than just a decimal number?

[Irwan · Accepted solution]

hello @TK1966 

is it possible to change it form the ribbon option?

select OPTIMUM column to show the ribbon then change into percent.

Hope this will help.

Thank you.

[v-yilong-msft · Accepted solution]

Hi @TK1966 ,

I think you can also change your DAX code, here I create a table as you mentioned.

Then I create a calculated column and it will give you  what you want.

Column = 
VAR _Total =
    SUM ( 'Table'[Sales] )
RETURN
    FORMAT ( 'Table'[Sales] / _Total, "0.00%" )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Irwan · Accepted solution]

hello @TK1966 

is it possible to change it form the ribbon option?

select OPTIMUM column to show the ribbon then change into percent.

Hope this will help.

Thank you.