Tree Map adding fields

[Ammulu_M]

Hi,

I need help and this is really urgent.

I have a measure which results few names of the agents.

Now I want to display those names in the tree map catgeory field. Could you please help me with that. I can't add that measure as calculated column.

[rajendraongole1]

Hi @Ammulu_M - if possible, can you please share with sample data and expectation with snapshots. I have tried with sample data we can achieve this by creating a calculated tables as below:

Country Table =

SUMMARIZE(

    Financials,

    financials[Country],

    "Selected country", [ProfitT]

)

[Ammulu_M]

I have measure which is giving the values as text like agent names.

badge agent aes is the measure I created. Now I want something like this.

in each band who are the employees 

[Anonymous]

Hi All,
Firstly  rajendraongole1thank you for your solution!
And @Ammulu_M ,if you want to implement visual objects that render this effect, I suggest you use calculated columns.

Employee_Badge = 
SWITCH(
   TRUE(),
   'Table'[PerformanceScore] >= 90, "Diamond",
    'Table'[PerformanceScore] >= 80, "Platinum",
    'Table'[PerformanceScore] >= 70, "Gold",
    'Table'[PerformanceScore] >= 60, "Silver",
   "Bronze"
)

You can also try using Measure for categorisation, but it can be a little tedious.

Gold = 
CALCULATE(
   COUNTROWS('Table'),
   FILTER('Table', [Badge_Agent_aes] = "Gold")
)

If you have any other questions, check out the PBIX file I've uploaded and I'd be incredibly proud if I could solve your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ammulu_M]

This is really helpful thank you!! 
I need employee names when I click on each tile.

problem statement

[Anonymous]

Hi @Ammulu_M ,
I can't open your file due to permissions settings, but your needs are achievable, we just need to set up tooltips in Power bi to do what you want!

If you have any other questions, check out the official documentation I've provided for you, I hope it helps!
Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ammulu_M]

I can't use tooltip. I want badge in the column and I can see the employees. to calculate the badge i need to calculate rank based on that rank if person got 1 & 2 I need give them badge as Diamond, 3 & 4 platinum etc...

Now my issue is I have rank as measure and badge as measure. i need to get badge in the column.

[Anonymous]

Hi @Ammulu_M ,
I can understand that your current requirement is to display the medals in the calculated column, if we call measure in the calculated column there will be a circular dependency, my suggestion is that you make rank a calculated column as well, and then call rank in the calculated column to display the medals, I hope my suggestion will be helpful.

Rank = RANKX(
ALL('Table'),
'Table'[PerformanceScore],,DESC,Dense)

Badge_Column = 
SWITCH(
   TRUE(),
   [Rank]<=2,"Diamond",
   [Rank]<=4,"Platinum",
   [Rank]<=6,"Gold",
   [Rank]<=8,"Sliver",
   "Bronze"
)

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ammulu_M]

Hi @Anonymous 
I was not able to create rank in the column, because I'm getting circualr dependency. Could you please help me more how can I do that.

[Anonymous · Accepted solution]

Hi @Ammulu_M ,

I think your problem may be the use of measure in the calculation column, which leads to circular dependency, you can try to change the measure to the calculation column, and then go to the reference may be able to solve your circular dependency problem, I hope this will help you!

If you have any other questions, feel free to contact me and I hope my answers are helpful!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.