Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix visual background color based on group row

I created a matrix visual table (per heat map). By table looks like this. The conditional backgroud color format for counts is applied to table. I am expecting conditional formating by row group (G-Support). To color format each row to identify max incidents counts and min incidents as below expected with i did in excel

 

current:

 

Expected:

 

Thank you

2 Replies

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion

    Anonymous  I understand you wish to use Row instead of column for conditional formatting. However, powerbi allows you to select only column in conditional formatting. One simple solution would be switch rows and columns to resolve the problem.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Currently Power BI does not support use conditional formatting in entire row of matrix just as negi007 stated. You can raise a new idea and add your comments there to make this feature coming sooner. Or you can refer the solution in the following threads as workaround.

    Conditional Formatting by Row in a Matrix

    Matrix Visual, Conditional Formatting, Row Values

    Solution to lack of conditional formatting by row?

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.