Forum Discussion

Ammulu_M's avatar
Ammulu_M
Icon for Helper I rankHelper I
2 years ago
Solved

Tree Map adding fields

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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

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's avatar
    Ammulu_M
    Icon for Helper I rankHelper I
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Ammulu_M
        Icon for Helper I rankHelper I
        2 years ago

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

        problem statement