The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I am using TreeMap and I am trying to differentiate the color based on KPI. Instead of a scale of colors, I would just prefer a bianry color option (two).
Say, if any value above the 5, would appear to be in Red and below that would be Green. I tried following this but my KPIs are dynamic and depend on slicer. Say instead of 5 the KPI would be 7 based on another selection from matrix. I would be able to get the selected value as a measure but I guess the table won't update dynamically based on the selection if I need to follow above tutorial.
Solved! Go to Solution.
Hi @Anonymous,
Did you create a measure? Based on my test the conditional formatting could work well based on a measure.
The formula of the measure is:
Measure = SUM(Table1[value])
For more details, please check the pbix as attached.
Regards,
Frank
Hi @Anonymous,
We can format the visual as the picture below. Then we can get the reuslt as you need.
For more details, please check the pbix as attached.
Regards,
Frank
Hi @Anonymous,
Did you create a measure? Based on my test the conditional formatting could work well based on a measure.
The formula of the measure is:
Measure = SUM(Table1[value])
For more details, please check the pbix as attached.
Regards,
Frank
Hi @Anonymous,
Could you please share your sample data or pbix to me? Please upload your file to One Drive and share the link here.
Regards,
Frank
So the conditional formatting would work only based on a fixed value but my KPI changes based on slicer.
User | Count |
---|---|
57 | |
54 | |
53 | |
47 | |
31 |
User | Count |
---|---|
175 | |
88 | |
69 | |
48 | |
47 |