Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi folks,
I went through numerous posts regarding conditional formatting but the reality for me is that I simply DON'T HAVE the options available in my Power BI Desktop (version 2.112.1161.0 64-bit, from December 2022).
Does anybody know how to set up conditional formatting for the bar colors in the chart below? The values in this chart are measurements that are defined as numeric (whole numbers), but the same behavior happens with non-measurement numeric fields.
Thank you so much!
P.
Illustration 1: conditional formatting does not appear as an option when you click on the dropdown of the fields:
Illustration 2: conditional formatting does not show as an option in the bar colors - and no "..." appears to access "Advanced Options":
Hi @pepe01 ,
Sorry, only replied now, In the Stacked bar chart, if there is only X-axis, there is no fx option to dynamically change the color, you can only manually change the color of each X-axis Value.
You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could anyone help??
Guys - would appreciate any insights on this matter. Thank you very much!
Hi @pepe01 ,
If there is content or values in the legend field in the axis of Visual, you can only change the color manually
If you drag field to Y-Axis and X-Axis to chart as below, you will have fx option.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear @v-yangliu-msft,
Thank you for your support. Unfortunately, this is not the case as there's nothing in the legend field, only in the X-Axis...
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |