Forum Discussion
Interactive Bar Chart Cross Filtering
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]))
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
Did you get any solution to this?
