Forum Discussion

pepe01's avatar
pepe01
Regular Visitor
3 years ago

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:

 

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

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

    • pepe01's avatar
      pepe01
      Regular Visitor
      3 years ago

      Dear Anonymous,

       

      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's avatar
    pepe01
    Regular Visitor
    3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.