Forum Discussion

mandih13's avatar
mandih13
Regular Visitor
3 years ago
Solved

Data Colours Option not visible

Hi,

I'm trying to do conditional formatting on graphs (clustered bar graph, or even stacked bar graph), but I don't have the data colours and therefore colour saturation options visible on any format menu's in Power Bi.  

Is there somewhere that you need to turn this on as an option? 

Kind Regards

Mandi

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  mandih13 ,

     

    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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  mandih13 ,

     

    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.

  • Hi mandih13 

     

    For the color settings on the bar charts you can have a look at the Bars settings.

     

    You can click on the fx button or show all in your category to assign colors to each category.

     

    Hope that is what you are looking for.

    • mandih13's avatar
      mandih13
      Regular Visitor

      Hi,

      This isn't an option for me.  I have columns (which I assume is the same as bars), but there is no fx button.

       

       

       

      • HughLa's avatar
        HughLa
        Resolver IV

        Yes, so the column charts have column settings and bar charts have bar settings respectively.

         

        What version of Power BI do you currently have?