Forum Discussion
Tree Map adding fields
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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
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.
This is really helpful thank you!!
I need employee names when I click on each tile.
problem statementHi 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 LearnHope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.