Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

stacked bar chart Condition Formatting Color

Hello Everyone, I want to create a Visual like this   and I created like this    The problem is when I drag legend into a stacked bar chart, it didn't allow a do Condition Formatting...
  • parry2k's avatar
    5 years ago

    Anonymous in the past when a visual doesn't allow conditional formatting (like Pie Chart or Line Chart), create a bar chart, apply conditional formatting and then convert it to the stacked bar chart., this technique worked for other visuals but not sure if it will work for Stacked bar chart.

     

    Or you can easily create using this matrix visual, change background and foreground based on the conditional formatting and it will look like bars.

     

    Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • Anonymous's avatar
    Anonymous
    5 years ago

    I have done using table and some condition Formating.