topic Re: Multiple conditional formatting in DAX Commands and Tips

Multiple conditional formatting

Jedahn — Wed, 12 Jul 2023 01:44:24 GMT

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.

Re: Multiple conditional formatting

Jihwan_Kim — Wed, 12 Jul 2023 02:20:32 GMT

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.

Re: Multiple conditional formatting

Jedahn — Wed, 12 Jul 2023 02:33:35 GMT

Thank you bro it works. God bless!