Forum Discussion

TK1966's avatar
TK1966
New Member
1 year ago
Solved

Format a number calculated column in Matrix Viz

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?

 

 

 

Need Help
  • Irwan's avatar
    Irwan
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

2 Replies

  • Irwan's avatar
    Irwan
    Icon for Super User rankSuper User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.