Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix with different number format by row/column

Hi  I have raw data as below and want to display the data as a matrix as shown in next picture. The user requirment is, some Columns such as Column Sim should show numbers in percentage for all KPIs and some of the KPI (such as KPI4)should show numbers in percentage in first two (Target, Actual Column).   How to achieve this? 

 

Need Help
  • Arul's avatar
    Arul
    4 years ago

    Anonymous ,

    First you need to pivot the column based on values and then write the below measure,

     

     

    Target_ = IF(SELECTEDVALUE('row/column'[KPI]) = "K4",FORMAT(SUM('row/column'[Target]),"Percent"),SUMX('row/column','row/column'[Target]))
    Actual_ = IF(SELECTEDVALUE('row/column'[KPI]) = "K4",FORMAT(SUM('row/column'[Actual]),"Percent"),SUMX('row/column','row/column'[Actual]))

     

    Thanks,

    Arul

1 Reply

  • Arul's avatar
    Arul
    Super User
    4 years ago

    Anonymous ,

    First you need to pivot the column based on values and then write the below measure,

     

     

    Target_ = IF(SELECTEDVALUE('row/column'[KPI]) = "K4",FORMAT(SUM('row/column'[Target]),"Percent"),SUMX('row/column','row/column'[Target]))
    Actual_ = IF(SELECTEDVALUE('row/column'[KPI]) = "K4",FORMAT(SUM('row/column'[Actual]),"Percent"),SUMX('row/column','row/column'[Actual]))

     

    Thanks,

    Arul