Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MikeBlairTP
Regular Visitor

Compare values and conditional formatting

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.

MikeBlairTP_0-1679589068283.png

 


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.

2 REPLIES 2
amitchandak
Super User
Super User

@MikeBlairTP , Assume you have selected Product A from slicer

 

the value of product C for measure

 

C = calculate([Measure] , Table[product] ="C")

 

Value of A is [Measure]

 

You can take diff, use that in conditional formatting using filed value option

 

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

 

 

Thank you for the video.  I create a new measure and can display both value from two independent slicers 🙂

 

But the conditional formatting is still confusing me.  I now want to compare both values, high one green (track record) if lower than (tp track track record) otherwise red.

 

MikeBlairTP_0-1679596913619.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.