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.
Hello,
Is there a way to set up the conditional formatting on the clustered column chart to use a range of values for the formatting. So in the example below, I would like to set ranges: 100-95%, 94%-90%, 89%-80%, <70%. Then color each of these ranges with a different color. I also looked at groups but that did not look like it would work.
Solved! Go to Solution.
Hi, @TomSinAA ;
Such as Dhrutivyasa-070 Said, you could set rules as follow:
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Based on my testing, if you have multiple metrics on the visual you can't set the conditional formatting on the columns. The FX button that is used to apply the formatting is only visible when a single metric is used. Hope this helps.
That is what I was seeing as well. Anyone able to find a work around?
Hi, @TomSinAA ;
Such as Dhrutivyasa-070 Said, you could set rules as follow:
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
there is no need to done Grouping in clustored column chart.
1. After Visulize the clustered colum chart , go into to filter of chart.
2. select column filters
3. Change the colors using the rules like Conditional Formatting.
Tell me, this logic is usefull or not.
When I select the visual and goto filters, it does not provide an option for step 2
After Visulize the clustered colum chart , go into to filter of chart.
2. select column filters
3. Change the colors using the rules like Conditional Formatting.
See screen shot
Am I going to the wrong spot?
Click on fx icon
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |