Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pepe01
Regular Visitor

Can't find conditional formatting in Stack Bar chart

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:

pepe01_0-1675366819424.png

 

Illustration 2: conditional formatting does not show as an option in the bar colors - and no "..." appears to access "Advanced Options":

pepe01_1-1675366989331.png

 

6 REPLIES 6
v-yangliu-msft
Community Support
Community Support

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.

pepe01
Regular Visitor

Could anyone help??

pepe01
Regular Visitor

Guys - would appreciate any insights on this matter.  Thank you very much!

v-yangliu-msft
Community Support
Community Support

Hi  @pepe01 ,

If there is content or values in the legend field in the axis of Visual, you can only change the color manually

vyangliumsft_12-1675408412733.png

vyangliumsft_13-1675408412735.png

vyangliumsft_14-1675408412736.png

vyangliumsft_15-1675408412739.png

If you drag field to Y-Axis and X-Axis to chart as below,  you will have fx option.

vyangliumsft_16-1675408412740.png

vyangliumsft_17-1675408412742.png

 

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...

 
 

pepe01_0-1675446918610.png

 

pepe01_1-1675447118689.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.