Forum Discussion

Jedahn's avatar
Jedahn
Frequent Visitor
3 years ago
Solved

Multiple conditional formatting

Hello. Need assistance regarding conditional formatting.

Here's an example:

I have 3 Divisions and every division has different percentage to reach.

Division 1: >= 80% Green and < 80% Red
Division 2: >= 70% Green and < 70% Red

Division 3: >= 60% Green and < 60% Red

Here's my actual example. Left side are their target per division and the right side column is their actual. 
The actual column will be the one i will apply the conditional formatting.

Thank you.

  • Hi, I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    I hope the below can provide some ideas on how to create a solution for your datamodel.

     

     

     

2 Replies

  • Hi, I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    I hope the below can provide some ideas on how to create a solution for your datamodel.

     

     

     

    • Jedahn's avatar
      Jedahn
      Frequent Visitor

      Thank you bro it works. God bless!