Forum Discussion
Pie tree chart getting confused
Community ChampionAnonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg_Deckler,
Here is the data sample and the problem statement.
| Vendor | Item | Demand | Supply | Difference |
| V1 | Item1 | 100 | 50 | 50 |
| V1 | Item1 | 90 | 80 | 10 |
| V1 | Item2 | 60 | 30 | 30 |
| V1 | Item2 | 400 | 230 | 170 |
| V1 | Item2 | 50 | 20 | 30 |
| V2 | Item1 | 10 | 10 | 0 |
| V2 | Item1 | 40 | 35 | 5 |
| V2 | Item2 | 45 | 30 | 15 |
| V2 | Item2 | 50 | 10 | 40 |
| V2 | Item2 | 20 | 6 | 14 |
Now I want to make a dashboard which contains two connected charts, one pie tree chart and another bubble chart.
When I create the pie tree chart it creates two branches v1 and v2 and another child branches for item from v1 and v2.
Now I create a bubble chart to chow the difference as the size and x and y axis as demand and supply respectively.
Here, I want to filter only v1 data in bubble chart when I click v1 branch on pie tree chart and v2 data when I click v2 branch on pie tree chart.
However, the problem is that since the item name is same for both the vendors the bubble chart only shows v1 data despite of selecting v2 on pie tree chart. While clicking on v1 on pie tree chart it works prefectly fine but for v2 it doesn't. This is my problem.
Refer to the diagram in my main post for better understanding.
Thanks,
Ali Asgar Zakir