Forum Discussion
Design suggestions
average_joe , the below, purple bar, can be a table and there you can do conditional formatting.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
Hi amitchandak ,
The issue I have is lining up the 2 visuals. The months of the column chart need to line up with the visual below, regardless of the date period selected by the user.
As a rough example, using a table with conditional formatting I can set this up like this for the view of last 6 months of data.
However, as soon as I select a different period such as last 3 months, the alignment between the column chart and the table are mismatched.
Using a column chart as the bottom visual (as per my first post) allows me to line up the values, however, I can't seem to figure out how to get the conditional formatting I'm after with this option.
So I'm trying to figure out:
- What visual to use so that the monthly values between the top stacked column chart and the bottom visual (whatever that may be) are aligned
- Formatting the values so that 0 shows up as a colour such as blue or green and anything else as orange or red.