Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
@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
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |