Dynamic category for chart axis and perform drill through as well as cross filter.

[dheer1610]

Hi 

Need some help/suggestion on below issue.

I've dataset which contains 10-20 Category depend upon customer and sample data look like as below.
Where I've different catagory(10-20) in col., Customer wants choose category from drop-down and compare SumCol1 and Sumcol2 . 

Cat1	Cat2	Cat3	Cat4	SumCol1	SumCol2
A1	B1	C1	D1	78	47
A1	B2	C1	D2	18	53
A1	B2	C1	D3	30	99
A1	B2	C1	D3	10	9
A5	B2	C1	D3	31	49
A6	B2	C6	D3	31	96
A7	B7	C7	D3	40	40
A7	B8	C8	D3	74	63
A9	B9	C9	D9	69	69
A9	B9	C10	D10	92	73
A11	B11	C11	D11	78	2
A11	B12	C12	D12	78	99
A11	B12	C13	D12	35	11
A11	B12	C14	D12	18	96
A15	B15	C15	D12	23	60
A16	B16	C16	D12	26	19

I've done unpivot to achieve the category selection in drop down. 

But Customer want to compare 4 category at the sametime as below image. 4 charts are controlled by 4 dropdown with help of "edit interactions". So, cat1 dropdown will have control on chart1 same as Cat2-->chart2 like that.

Prob: Whenever I select a bar from chart 2 or in other charts it will crossfiltered others chart, but show 0 as below image. I want it should reflect the imapact of cat2 bar 1 on other charts also. These catagory are not fixed and It can increases to 15/20.

Requirement was user want to see impact of "B2" from category -2 on others catagories in higlhted format as below. In the below graph I hardcoded the cat. values in every graph then is working fine. But category are more than 15/20.

Expected result as below but cat. need to be dynamic.

Prob2. I created a drill through also but evrytime I do drill through I passes as value and charts get filtered according to value.But user want to see impact of B1(cat2) on other category values for example.  B1(cat2) drillthrough to new page where Cat1(values).

@Jihwan_Kim @Greg_Deckler @amitchandak  any idea/Suggestion/Help how I can do this . Any model change will help?

[amitchandak]

@dheer1610 , I think interactions can help . Right top only interact with Right bottom. Right bottom with Left bottom, Left bottom with left top, Based on what I got.

Change interactions and try https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

How Interactions Work- Split Page using interactions to compare: https://youtu.be/GIfRKzhMaR4

[dheer1610]

@amitchandak same I implemented too.

Catagory1 drop down only controlling Chart1.

Catagory2 drop down only controlling Chart2.

Catagory3 drop down only controlling Chart3.

But the challenge is select any bar in any chart it's not filtering/highlighting the impact on other charts. It's showing zero as result in other charts.