cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBIUWO
Helper III
Helper III

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"

1 ACCEPTED SOLUTION
MFelix
Super User III
Super User III

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:

MFelix_0-1612190859537.png

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
MFelix
Super User III
Super User III

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:

MFelix_0-1612190859537.png

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Greg_Deckler
Super User IV
Super User IV

@PBIUWO - Not sure, can you post a mocked-up image of what you are looking to achieve?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors