Forum Discussion
Treemap - dynamic grouping question.
Once you create the table as requested earlier,
Please select entire table into powerbi query. Now, create 2 New columns as:
TAT = datediff(Testtbl[receiveddt].[Date], Testtbl[reportdate].[Date], day)
15DTAT = if(Testtbl[TAT] < 15, 1, 0)
Create New Measure as:
15DTAT% = CALCULATE(SUM(Testtbl[15DTAT])/count(Testtbl[claimkey])*100)
In the treemap, select:
healthplan, color and 15DTAT%. This will show you every healthplan with its corresponding 15DTAT% value.
What I am looking for is:
In a treemap only 2 blocks - Green and Red. Green represents # of Healthplans having 15DTAT% >= 90. Red represents # of Healthplans having 15DTAT% < 90.
In this case, the healthplan ABC has 100% and JKL 90.48% and hence Green color would be for 2 healthplans. DEF, GHI and MNO has < 90% and hence Red color would be for 3 healthplans.
At my end, it appears as below:
Hello Hardik,
Were you able to reproduce the problem? Please let me know. Thanks.