Facing Problem to create pie chart in Peer Analysis.
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.
- 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:
- 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.