Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional formatting based on bechmarks that differ by columns

Hello, I have a matrix with facilities listed in the rows and tests listed in the columns. The values in the middle of the table are a measure calculated as the number of times a facility exceeds th...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous 

    You need to go to FORMAT section (1).

    There choose CONDITIONAL FORMATING (2).

    Choose the field to format. Another window will pop up.

    Choose RULES (3), and BASED ON FIELD - Will be the new calculated field (4).

    In the example, I format NAME according to COUNT of IDs.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks so much for the assist Anonymous!

 

The else statement isn't needed with the switch.  Instead, I added a >= and a < clause - but no dice. 

 

Exploring the column_result option. If I want to format the column according to this number/column (1=green,2-red), where in PowerBI can I apply the format to each column individually?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

You need to go to FORMAT section (1).

There choose CONDITIONAL FORMATING (2).

Choose the field to format. Another window will pop up.

Choose RULES (3), and BASED ON FIELD - Will be the new calculated field (4).

In the example, I format NAME according to COUNT of IDs.