Forum Discussion
AnkitaaMishra
11 months agoSuper User
Treemap 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 ...
- 11 months ago
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
- 11 months ago
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! 🙂
MFelix
11 months agoSuper User
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