Forum Discussion
Custom Colors for Line and Clustered Column Chart
I have the following chart that even though I set the Column Colors for 0-5 and 5+ Days, ever time I change the selection for the whole report it loses or does not use what I set.
It does have two tiers, but what do I need to do to get 0-5 to always be green and 5+ days always red?
1 Reply
bdehning , if 0-5 Days and 5+days are legend values. (Of create a calculation group on measures)
and use both of them on the axis and and sort on axis and concatenate label off , and then create a measure to color the values
refer
Concatenate Label off : https://youtu.be/QgI0vIGIOOk
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
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
