Highlighting Row in Matrix without Slicer Interaction

[TMLewis]

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!

[v-easonf-msft · Accepted solution]

Hi， @TMLewis 

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/ 

https://www.mssqltips.com/sqlservertip/6265/power-bi-conditional-formatting-for-matrix-and-table-vis...

Best Regards,
Community Support Team _ Eason

[amitchandak]

@TMLewis , 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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values