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