Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How can I format ROI on the matrix below to show percentage values?
And leave the other rows formatted as numbers without decimals?
Solved! Go to Solution.
Try the below measure and replicate the same for Target.
Actual 2 = IF(MAX(Table1[KPI]) = "ROI",FORMAT(SUM(Table1[Actual]),"Percent"),SUM(Table1[Actual]))
Try the below measure and replicate the same for Target.
Actual 2 = IF(MAX(Table1[KPI]) = "ROI",FORMAT(SUM(Table1[Actual]),"Percent"),SUM(Table1[Actual]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |