Forum Discussion

Ammulu_M's avatar
Ammulu_M
Helper 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 with that. I can't add that measure as calculated column.

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.

9 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super 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
      Helper 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.