Forum Discussion
Pie tree chart getting confused
Hi Team,
There is a problem which I am facing right now while using pie tree charts, as per the below diagram, the data have different vendors but 2 vendors can have same Item with same name. Now when I try to select vendor2 it stucks and even if gets selected the other chart linked to pie tree shows vendor1 only and not vendor2.
I am not sure why this is happening but it should not cause I am selecting vendor2 here and not vendor1. And when I change the name of all the items i.e. different in both the vendors it work fine. But for me the data contains 1 item for 2 vendors and vice versa.
So do you guys have solution for this problem and if yes, can you please share the same with me asap.
Thanks,
Ali Asgar Zakir
2 Replies
Anonymous 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
