Solved: How to format a specific cell or row in a matrix?

webportal · ‎12-12-2018

How can I format ROI on the matrix below to show percentage values?

And leave the other rows formatted as numbers without decimals?

Omega · ‎12-12-2018

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]))

Anonymous · ‎08-04-2019

See if this idea can be of any help. https://youtu.be/VIYJ8YM2huQ

Omega · ‎12-12-2018

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]))

How to format a specific cell or row in a matrix?