Forum Discussion
Is it possible to do Conditional Formatting (Highlighting) selected rows in a Matrix Table?
Is it possible to do Conditional Formatting (Highlighting) only the Rows that are "Selected" from a filter in a Matrix Table?
I created a page where the user can select item codes from a filter. With a measure in the Matrix Table, it also populates related item codes and its sales history in the same table.
As this might look confusing, I'm wondering if it's possible to do conditional formatting on the Matrix for only the items that are selected in the filter so the user can distinguish the related items and selected items.
Under conditonal formatting, I only see it availabe for the "Values". I want to highlight the Item, and its under "Rows"
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?
3 Replies
PBIUWO - Not sure, can you post a mocked-up image of what you are looking to achieve?
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-valuesHi 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?
