Forum Discussion

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

Treemap - dynamic grouping question.

Hi,   I have a treemap that has supplies category, each colored either green (if the sales for that supplies category is above 90%), or red (if the sales is below 90%). So, my treemap has bunch of ...
Need Help
ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

Hardik,

 

This is exactly what I am trying to do. I have a detailed treemap that you have shown. I want an upper level treemap done. How to achieve this?

 Please see the attached screenshot which shows the supplies categories marked in red and green. What I want is another treemap (which is upper level) which shows only red and green section which can be drilled down to get to the level that I have shown above. Does it call for grouping? You have demonstrated the outcome, I want to know how to achieve this. Sorry, I am very new to Power BI so detailed instructions will really help me a lot. Thanks.

 

Please note that everytime I fetch data from SQL Server DB, there may not be both green and red at upper level. if all the supplies category fall in 90% or above then the only square I will find would be green (red will be missing due to no supplies category falling in red zone).

 

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

Also, how to find out the number of green boxes and red boxes in the 2nd level treemap that I have? In the example I have shown previously, there are 6 green boxes and 5 red boxes. Is there a way to numerically demonstrate them?