How to do conditional formatting with field value

[arvindyadav]

Hi Team,

I am using conditional formatting by using field value. But not getting what I needed.

Please find the image for your clarification.

why this is not working in my case but it is working for others.

Thanks,

Arvind

[v-xicai]

Hi @arvindyadav ,

After creating the formula above, you may also need to set conditional formatting for the field [Profit], choose "Field value" based on your measure [Conditional Format] .

Best Regards,

Amy

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

[arvindyadav]

Hi @v-xicai ,

I did the same but nothing is reflected on the table.

where data source is taken from Onedrive file.

[v-xicai · Accepted solution]

Hi @arvindyadav ,

By my test, this formula works well. You may set conditional formatting for the field [Profit], choose "Field value" based on your measure [Conditional Format] .

You can download my test pbix file.

Best Regards,

Amy

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