The easiest way would be to add Americano, 0, Sydney to your data.
Yes that is true, But my case my dimension is having too many values which i really can't edit.
Thanks for that but if i am not wrong what you have given is just filtering out with the values what is having right. But i want all the dimension values irrespective of the count they possess and should display as 0 if they dont have value.
In this case, I will suggest to use parameter instead of filter.
Given the nature of this visualization, I'm pretty sure it isn't possible to show a dimension that is either not present in the data, or even if it were present in the data but equal to 0. What creates the square in the visualization is the size of Count. If Count is 0 or null or missing, it cannot show up - as the size is 0 or null. This shows a Coffee Type present but with 0:
And this is its map: Coffee C is still in the legend at least, but it cannot show up in this type of viz.
What you could do is create a second object that has the same filters as the tree map. It will be a table that lists all the dimensions in the treemap. You could add color coding and the value if you wanted. Something like this.
Then when you select a Region with no dimensions, the header will still show the empty dimensions.
To get the empty dimension values to show in the Header table, go to Analysis > Table Layout > Show Empty Columns.
Hope this helps,
Treemap.twbx 358.6 KB