The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
I have attached an image for reference
@amitchandak @Greg_Deckler @diex @aj1973 @BA_Pete @Jihwan_Kim @SanketBhagwat @Allison
@Infijeevan , 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?
User | Count |
---|---|
78 | |
73 | |
38 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |