Forum Discussion
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 Color.
is that possible with a stacked bar chart?
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.⚡
6 Replies
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 well done, we were on the same wave. glad it worked out for you. Cheers!!
Fowmy any solution?