Forum Discussion
Colour Row Groups in Matrix Visualisation
Hi Richard_Halsall ,
As far as I know, the calculation in Power BI will base on columns. However, [TRIR] and [Target] are from different columns. So we need to set the conditional formatting for each column/measure.
In my sample, I set [TRIR] show blue and [Target] show orange by Field value in Background conditional formatting.
Color for Target = "Orange"Color for TRIR = "Blue"Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Richard_Halsall ,
Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your issue or share me with your pbix file without sensitive data.
Best Regards,Rico Zhou
Hi Richard_Halsall ,
As far as I know, the calculation in Power BI will base on columns. However, [TRIR] and [Target] are from different columns. So we need to set the conditional formatting for each column/measure.
In my sample, I set [TRIR] show blue and [Target] show orange by Field value in Background conditional formatting.
Color for Target = "Orange" Color for TRIR = "Blue"Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , I did manage to do this also I was trying to get the labels TRIR & Target to be coloured as well Thanks
Hi Richard_Halsall ,
Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your issue or share me with your pbix file without sensitive data.
Best Regards,Rico Zhou