Interactive Bar Chart Cross Filtering

[Anonymous]

Hi Folks

I need to create an Interactive Visual of which consists of 3 bar charts

Bar chart 1- Products

Bar chart 2 – Product Defect Reasons

Bar chart 3- Manufacturing Plant

and a TOP N filter which filters the top n bars based on the selected n and contains a cross filter functionality such that

• By clicking on a product bar chart 1-> top n bars of the chart 2 show the top n defects reasons of the selected Bar in chart 1 and then by clicking on any Bar in chart 2 -> Top n bars of chart of chart 3 showing the associated plant of the selected reason in chart 2

I have attached an image for reference

@amitchandak @Greg_Deckler @diex @aj1973 @BA_Pete @Jihwan_Kim @SanketBhagwat @Allison 

[amitchandak]

@Anonymous , You can use TOPN filter at visual level fixed

You can create TOPN measure for each one with dynamic N and can use that

I think drill should work unless you point out some specific case

example - one for each visual based on axis column

Top N =calculate([M1], TOPN([selected N],allselected(Table[Event]),[M1],DESC), values(Table[Event]))

[Anonymous]

Thanks for getting back Amit : Those steps have been followed but still the issue persists the following are the measures that i have used

toprankingmeasuresprod = IF('Measure Table'[product rank]<='Measure Table'[SelectedTopNValue],'Measure Table'[total complaints])

toprankingmeasuresreasons = IF('Measure Table'[reasons rank]<='Measure Table'[SelectedTopNValue],'Measure Table'[total complaints])

toprankingmeasureplant = IF([plantrank]<='Measure Table'[SelectedTopNValue],'Measure Table'[total complaints])

I think its more complex than that. let me re-explain the issue

so i have a top N slicer which has [Top 1, Top2, Top 3.....and so on] after selecting say Top 5 I have Top 5 bars displayed for all the 3 bar charts now i want an additional cross filtering functionality where

by clicking 1 bar in a bar chart of the top 5 bars from products table i get the top 5 product defect reasons for the selected product bar and then cliciking on 1 Bar from those top 5 reasons i get the top 5 plants

please check the attached image in the 1st post for reference As of now in PBI if i click on any bar i get the following response

@amitchandak 

[adi38612]

Did you get any solution to this?