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
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ppgandhi11

 

You can add a calculated column to your table that dynamically determines if the value should be red or green.

 

This will only be dynamic based on data coming into the model and filters will not have any effect.