Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

conditional color Stack column chart

Hello Everyone, how do i color first 2 bars exactly like this and rest of the bar in the stack,please help me out with a solution.If possible explain indetail.
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    According to your screenshot, I think you have added a column into Legend field in your Stacked Column Chart. So we can see multiple colors in Color in Columns.

    As far as I know, Power BI doesn't support us to use conditional formatting after we use Legend in Statcked Column Chart. Power BI will determind the color for each legend based on theme. If we need to change the color for legends, we need to select the legend and choose the color we need manually.

    Your demand is a good idea, while it is not supported to implement in Power BI currently.
    You can vote up this idea for this function :

    Enable Conditional formatting for Legends and columns series in Stacked bar

    Or you can submit a new idea to improve the Power BI.
    It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Arul's avatar
Arul
Super User
4 years ago

Anonymous ,

Write a simple measure using selected value in switch function along with your condition and use it in condtional formatting.

Thanks,

Arul

Anonymous's avatar
Anonymous
Not applicable
4 years ago

please could breif it in step by step.

  • Arul's avatar
    Arul
    Super User
    4 years ago

    Anonymous ,

    1. Write a measure like this for your requirement

    2. Use that measure in conditional formatting (fx).

     

    3. Set your measure in field value category.

    Thanks,

    Arul

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      If you could see my snippet, thier is no option of conditional formating

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        According to your screenshot, I think you have added a column into Legend field in your Stacked Column Chart. So we can see multiple colors in Color in Columns.

        As far as I know, Power BI doesn't support us to use conditional formatting after we use Legend in Statcked Column Chart. Power BI will determind the color for each legend based on theme. If we need to change the color for legends, we need to select the legend and choose the color we need manually.

        Your demand is a good idea, while it is not supported to implement in Power BI currently.
        You can vote up this idea for this function :

        Enable Conditional formatting for Legends and columns series in Stacked bar

        Or you can submit a new idea to improve the Power BI.
        It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.