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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
GAPER
Post Patron
Post Patron

Swap Metrics Conditional Formatting is wrong

I am using the instruction here

https://www.thedataschool.com.au/minghsuan-lee/swapping-metrics-in-power-bi/

 

to create a swap metrics but when i apply conditionaly formatting say >10%. If any metrics >10%, it will apply the color formatting but i only want it apply when I select that metrics and that metrics >10%. How do i achieve this? Thanks

 

 

It's becoming really funky 

2 REPLIES 2
lbendlin
Super User
Super User

Base your conditional formatting on another measue. In that measure you can check if the selectedvalue of the slicer is your "metric"  (rather unfortunate name for a measure)  and then apply the color coding selectively.

Sorry I don't think I understand this. Could you please Elaborated a bit?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.