Compare values and conditional formatting

Question

I have a table of products that have scores. In the example below, I want to compare a product (using a slicer) to Product C.

If some selects Product A or B from the slicer then it will compare against the scores for Product C.

I also need to use conditional formating to highlight green or a green icon when the score for product c is lower than the select product.

amitchandak · Answer

Anonymous , Assume you have selected Product A from slicer 
&nbsp;
the value of product C for measure
&nbsp;
C = calculate([Measure] , Table[product] ="C")
&nbsp;
Value of A is [Measure]
&nbsp;
You can take diff, use that in conditional formatting using filed value option
&nbsp;
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
&nbsp;
How to do conditional formatting by measure and apply it on pie? https://www.youtube.com/watch?v=RqBb5eBf_I4&amp;list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8Lhttps://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
&nbsp;
&nbsp;

anonymous · Answer

Thank you for the video.&nbsp; I create a new measure and can display both value from two independent slicers 🙂&nbsp;But the conditional formatting is still confusing me.&nbsp; I now want to compare both values, high one green (track record) if lower than (tp track track record) otherwise red.&nbsp;&nbsp;

Forum Discussion

Compare values and conditional formatting

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting