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 forma...
General Comment
Tips and Tricks
  • 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.

HughLa's avatar
HughLa
Resolver IV
3 years ago

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
    3 years ago

    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
      3 years ago

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

       

      What version of Power BI do you currently have?

       

      • mandih13's avatar
        mandih13
        Regular Visitor
        3 years ago

        Hi

        I'm on 2.115.1006.0.