Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Solved! Go to Solution.
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?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
@PBIUWO - Not sure, can you post a mocked-up image of what you are looking to achieve?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |