Pie tree chart getting confused

[Anonymous]

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 

[Greg_Deckler]

@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.

[Anonymous]

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