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, I have a line and clustered column chart that looks like this:
any ideas on how to get conditional formating so that either the background or text or even the bar turns red if it's above 2%?
Only thing I can see is to do it manually under Data Colors --> Show All which wont work, because then the bar stays red when the slicer is used.
TYIA
Solved! Go to Solution.
Hi @kressb ,
On the Data color options of the chart you will have 2 options first one is regarding the line values and the second one that sould say default color.
On the second one if you check the rigth side it will appear 3 dots where you can select the conditional formatting then just set your rule.
Don't forget to set the option on the rules to number instead of percent.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @kressb ,
On the Data color options of the chart you will have 2 options first one is regarding the line values and the second one that sould say default color.
On the second one if you check the rigth side it will appear 3 dots where you can select the conditional formatting then just set your rule.
Don't forget to set the option on the rules to number instead of percent.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |