Need to change the color of the value by using DAX

[thinkpad]

Hi Experts,

I have a following scenario i.e the values which are greater than 200 should display the red color, by using DAX need to get that one. Could any one please help.

Thanks in advance.

[DataNinja777 · Accepted solution]

Hi @thinkpad ,

You can use the dax formula like below to produce your required output.  Please use this in your conditional formatting of the measure. 

I attach an example pbix file.  

Best regards,

[Anonymous · Accepted solution]

Hi @thinkpad ,

Your solution is great, @DataNinja777 . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference. 

I create a table.

Then I create a measure and here is the DAX code.

Measure = IF(MAX('Table'[Total])>200,"Red","Black")

Next I put it into conditional formatting.

Finally you will get what you want.

Best Regards

Yilong Zhou

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

[thinkpad]

Thanks

[DataNinja777 · Accepted solution]

Hi @thinkpad ,

You can use the dax formula like below to produce your required output.  Please use this in your conditional formatting of the measure. 

I attach an example pbix file.  

Best regards,