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 Power BI Users,
I am seeking help regarding Conditional Formatting for the Line and Clustered Column Chart attahced below. I need the columns to turn "Red" if it exceeds the budget (i.e. goes beyond the target line) and turn "Green" if it is at or under the weekly bedget (i.e. equal to or below target line).
Conditional formatting option is available in matrix and table. Is it also possible in charts and other visualizations? Kindly assist. Any inputs are much appreciated!
Thanks & Regards,
Anuj
Solved! Go to Solution.
Hi @Anonymous ,
As the reply said above only when you have one column value then you can set conditional formatting.
You can create measure like
Measure = IF(AVERAGE('Table'[actual])>AVERAGE('Table'[budget]),1,0)
Then create rule as below.
Result
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
As the reply said above only when you have one column value then you can set conditional formatting.
You can create measure like
Measure = IF(AVERAGE('Table'[actual])>AVERAGE('Table'[budget]),1,0)
Then create rule as below.
Result
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can click on the three dots next to Default Color as below, this will expand conditional formatting, however it will only show if you have only one value in the visual.
Thank you! Enabling conditional formatting for any visual with that option is very useful.
@Anonymous
Refer: https://chandoo.org/wp/conditionally-format-visuals-in-power-bi/
https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |