Facing Problem to create pie chart in Peer Analysis.

AMAN SHAIKH 40 Reputation points
2024-06-06T19:11:00.46+00:00

Hey everybody,
Hope you are doing well.

I am currently working on a project called peer expense analysis. Here I have Data in this format.

ID Category Spends Clusters

1 A 100 1

2 B 150 2

3 A 200 1

I have 1000 Customers, 20 categories, 50K Txn with 7 clusters.

  1. First Pie Chart
    I want I want to do peer Analysis on power Bi app, I have uploaded the Data and created the First pie chart which Has Category wise spends, top 5 category with ID slicer when we want to see specific ID spends then select from slicer and get in which category he is spending.

Now My problem:

  1. Second Pie Chart
    Now in my second pie chart I want when I select specific ID in First chart then other IDs spends which are in the same cluster there avg should show on this 2nd pie chart. **

Summary:**
I want to do comparison like I am 22 year old, people like me are in same cluster. So I want visualization where if i select my ID I should able to see my spends and other peoples spending which are of same of my age ( Basically which are in my cluster).

**Is there any efficient way to do this?
please help me any you have any solution to this problem.
Please attach snippet of each step, it'll be very helpful for me.
**
Thanks & Regards,
Aman Shaikh.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,392 questions
0 comments No comments
{count} votes