Forum Discussion
Is it possible to do Conditional Formatting (Highlighting) selected rows in a Matrix Table?
- 5 years ago
Hi PBIUWO ,
If you add a measure that returns for example a 1 for all the values that are selected you can have that condittional formatting set to the specific row, however there are some questions regarding how you have you visualizaitons setup.
Has you can see in attach file the values of categories selected on the slicer are with a different colour:
How do you select the values for the item codes? Is it a related table or the same one?
Does the matrix changes with the slicer changes?
Can you share a sample file?
PBIUWO , for this you have to use an independent item table. so that it does not filter the row. Then you have to do formatting of all columns/values, as there is no row formatting in Power BI
Do this for all measures/values. In conditional formatting use "field value" and use this measure
color measure = if(max(Table[item]) in values(item[item]), "green", "white")
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values