Forum Discussion

sperry's avatar
sperry
Resolver I
6 years ago
Solved

Row Conditional formatting on text in a Matrix visual

I have a Business Plan report table that needs conditional formating on the Status and repeated values in the first column to be grouped.  Table does not allowing grouping by row value so it looks l...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi sperry ,

    You can try to create the following measure:

    Measure =
VAR __q =
    SELECTEDVALUE ( 'Table'[Q1 Project Status] )
RETURN
    SWITCH (
        TRUE (),
        __q = "Not Started", 1,
        __q = "On Track", 2,
        __q = "Minor Delay", 3,
        __q = "Completed", 4
    )

    Right-click on the 'Values' field in Matrix - Conditional formatting - Background color - Format by Rules - Based on Measure, and then customize the format of the condition you want, as shown below:

    Here is a demo, please try it：

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EVWcE3RDCftDvCqRMYO_r2EBwb-Rrj8AQZZ465w4gAgfmA?e=CWi9RD

    Best Regards,

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

MyriamW's avatar
MyriamW
Frequent Visitor
3 years ago

I have nearly the same problem but I do not understand the solution.

 

I am still not able to choose conditional formatting for rows, only for values. In your example I would like to have different background colors for values in the column "projects&initiatives", but this is currently not possible in matrix visual, is it?