Forum Discussion
Highlighting Row in Matrix without Slicer Interaction
Hi, I've got a challenging problem!
I have a dashboard with 2 slicers which affect 3 graphs (not shown) and a matrix at the bottom.
The slicers allow only 1 company per selection so the line charts operate correctly.
Here's the challenge:
1. The user wants to see all Company Names and their sales in the matrix table (so I turned off the interaction between Company Name slicer and the matrix)
2. The user doesn't want the other rows to disappear when a row is selected, but he wants to see the row highlighted.
3. I've seen some DAX solutions that come close, but don't get me exactly where it needs to be. Has anyone ever solved for this before?
Thanks so much for your help!
Hi， Anonymous
As of now ,there is no such an option or feature to highlight specific rows include blank values for Matrix visual in Power BI currently.
As a workaround, you can try to apply background conditional formatting in matrix value.
Measure_conditional formatting = IF ( SELECTEDVALUE ( 'Table'[Category] ) in VALUES( 'slicer category'[Category] ), "light green", "white" )Related posts:
https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/
Best Regards,
Community Support Team _ Eason
2 Replies
- amitchandak
Super User
Anonymous , I matrix you can not highlight the rows(row of table) and Row/column(pivot), You can have background color for values
Create a color measure and use that for all value columns with Field Value option in conditional fomatting. Prefer to create an independent Country Table (assumed)
Color =
if(Max(Table[Country]) = selectedvalue(Country[Country]), "Green", "Red")
Color =
if(Max(Table[Country]) in values(Country[Country]), "Green", "Red")Refer steps
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 - v-easonf-msft
Community Support
Hi， Anonymous
As of now ,there is no such an option or feature to highlight specific rows include blank values for Matrix visual in Power BI currently.
As a workaround, you can try to apply background conditional formatting in matrix value.
Measure_conditional formatting = IF ( SELECTEDVALUE ( 'Table'[Category] ) in VALUES( 'slicer category'[Category] ), "light green", "white" )Related posts:
https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/
Best Regards,
Community Support Team _ Eason
