Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Treemap coloring by category

Hi everyone.   I have treemap with data, item and category, where each item has two categories and data for categories. It looks like this: I wanted to color by category, but in data colors ...
Need Help
  • mwimberger's avatar
    mwimberger
    7 years ago

    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

     

     

     

     

     

mwimberger's avatar
mwimberger
Icon for Resolver II rankResolver II
7 years ago

Hi Anonymous 

 

Or you can try it this way...which might be exactly what you are after?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

mwimberger 

 

In this example:

2019-07-23_13-27-20.jpg

How can I change border colors between items?

Regards,

Yerkhan

  • mwimberger's avatar
    mwimberger
    Icon for Resolver II rankResolver II
    7 years ago

    Hi Anonymous 

    So adding a border only adds a border to the visual outline. This is different to the MS Excel Treemap which adds a border to the items and you can adjust the thickness of these. (Maybe suggest this as an idea at ideas.powerbi.com) 

    I tried a couple of things - the only thing that made a bit of a difference was changing background colour - which changed it only marginally using a black background. Here are some examples.

     

    So the built in tree map is not that customisable 😥.

    Not sure whether you want to bake your own, or find other customisable ones ( there is a great list here: https://www.visualisingdata.com/resources/  with https://www.treemap.com offering an API or desktop version at a cost). Charticulator https://charticulator.com/index.html (which I mentioned earlier I think) has the following to say in its white paper https://donghaoren.org/publications/infovis18-charticulator.pdf :....." Besides, we can further extend Charticulator’s expressive range by supporting additional specialized layout algorithms (e.g., treemap and force-directed graph layout)". Not sure if that means it is still coming in a future release.

     

    Hope this helps. 

     

    Cheers and have an awesome day

    Manfred

    Hope I have been able to help in some small way