Forum Discussion
AnkitaaMishra
Super User
Super UserTreemap conditional formatting help
Hi All,
I’m trying to apply conditional formatting on a Treemap visual in Power BI. The requirement is to have two different color palettes applied dynamically based on the number of departments ...
Hi AnkitaaMishra ,
This is not an easy setup since you want to do a gradient and need to setup the gradient values.
Check this video with some advance DAX for colouring:
https://www.youtube.com/watch?v=c2mZimSeEL4
Hi MFelix ,This is exactly what I was looking for! I created a DAX measure using HSLA colors, ranked the departments, and it worked perfectly. Huge thanks for sharing the solution! 🙂
MFelixSuper User
Super UserHi AnkitaaMishra ,
This is not an easy setup since you want to do a gradient and need to setup the gradient values.
Check this video with some advance DAX for colouring:
https://www.youtube.com/watch?v=c2mZimSeEL4