Forum Discussion
Solved
Conditional format a measure in Matrix based on a column heading
Hi everyone
I am fairly new to Power BI and need some help. this is something I could do in my current BI tool but haven't found a way in Power BI.
I have a cross tab (matrix) as below , with multiple KPI's for a list of services. In the raw data we have already calcualted the %change between two periods , it is possible to just show the %change column formatted as a %age and keep the other columns as numbers.
| kpi 1 | ||||||
| Current month | last month | % change | current ytd | last ytd | % change | |
| Svc 1 | 80 | 100 | -0.25 | 5 | 15 | -2 |
| Svc 2 | 20 | 50 | -1.50 | 16 | 21 | -0.31 |
yes, that is possible. Click on the measure in your field list on the right then at the top change its global format. You can also change the format just for the visual.
Thank you for your response, it worked for me.
