Forum Discussion
Helper VTreemap - dynamic grouping question.
Helper VI tried creating a sample data that you have showed and it worked the way you have demonstrated. Unfortunately my case does not seem to be the same. Since the column1 that you have shown is a measure in my case, it is dependent on a qualifer (payor in this case) so as soon as i select it, i get to level2 of treemap directly since now the colors are shown based on payor.
I am very new to power bi so guessing at this time, but if the column1 would have been a calculated measure based on other fields, then would you still expect the same behavior that you have demonstrated? if so, then I am missing something. Hope we have a capability to share the pbix to show the issues. Thanks.
Continued Contributorhey i
created a measure average and the treemap works fine on this side.
Measure = AVERAGE(Table1[Column1])
- ppgandhi11
Is there a way to share .pbix file? If so, I can send you my file to have you show me what I am missing.
This is how my data in table format looks like in power bi. As you can see, the table format looks good. However when I try to create treemap with "15D TAT (%)" and colorcode selected, then the colorcode directly goes to tooltip and not in other visualization (e.g. values or details). As soon as select the Health Plan also in it, then I get the 2nd level treemap where each box represents the health plan.
I am stumped about what is missing.
- Hardik
- ppgandhi11
This link says there is no functionality to attach the file. We need to use dropbox or onedrive etc to share the content. Don't know how to go about it.