Forum Discussion
Treemap coloring by category
Hi Anonymous
Here is a solution that may work for you.
It involves a couple of things and doesn't keep the treemap formatted exactly as intended but it may be a small compromise if the shading is important.
In the solution below, you keep item and category grouped under Group and then expand one level in the hierarchy in the visual ( the double arrow pitchfork icon). You need to have a column created which strips the Category from the Category name and create an advanced controls rule which controls the colour fill. I just used min 1 and max 2 , but if you have multiple categories you can use rules-based formatting too.
Bear in mind the advanced controls is not available with any field in the Details section
Here are the steps:
Cheers
Manfred
Resolver IIHi Anonymous
Here is a solution that may work for you.
It involves a couple of things and doesn't keep the treemap formatted exactly as intended but it may be a small compromise if the shading is important.
In the solution below, you keep item and category grouped under Group and then expand one level in the hierarchy in the visual ( the double arrow pitchfork icon). You need to have a column created which strips the Category from the Category name and create an advanced controls rule which controls the colour fill. I just used min 1 and max 2 , but if you have multiple categories you can use rules-based formatting too.
Bear in mind the advanced controls is not available with any field in the Details section
Here are the steps:
Cheers
Manfred
Hi mwimberger
Thanks for your answer.
Unfortunately, this doesn't quite works for me.
So, it is not possible to color with details present and make color by details, right?
Regards,
Yerkhan
- mwimberger
Hi Anonymous
That right - as soon as you add a field to the details section , the advanced color formatting in Data Colors isn't available.
Another solution may be to use the Treemap Bar Chart custom visual from MAQ Software available in the marketplace or here https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000043?src=office&tab=Overview
- mwimberger
Hi Anonymous
Or you can try it this way...which might be exactly what you are after?
Thanks, mwimberger, this worked for me. It's a bit frustrating that the Power BI user interface for the Treemap visual makes it so difficult to apply a simple color gradient though.
