Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |