Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Interactive Bar Chart Cross Filtering

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 Anonymous Allison 

Need Help
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        adi38612
        Frequent Visitor
        1 year ago

        Did you get any solution to this?