Forum Discussion
Automating Column colors for each year
bdehning , If you are not using legend or two measures, you can use field - conditional formatting. You can create a measure like below and use in coditional formatting using field value option
COlor = Switch(True() ,
max(Table[Inception Year]) = Year(Today()) , "Blue",
max(Table[Inception Year]) = Year(Today()) -1 , "Green",
"Red"
)
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
It seems from my research that the functions for conditional formatting have been removed by Microsoft with this new rollout. There is supposed to be an option to revert to Classic visual from Modern visual but for our current PBI tenent, we cannot revert.
I heard they may restore all those features over the next months, but anyone else know anything abut this.
I tried all kinds of options but FX never appeared unless I removed the year field in Legend, so never got what I wanted.