Forum Discussion

fchukoskie's avatar
fchukoskie
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Drill down and filter

In a Power BI desktop stacked bar chart, I'd like to drill-down by clicking to see which 2nd-level items (Subjects) make up the 94 replies in a survey. However, that double-click renders the entire c...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    If that is how it is working for you, it sounds like it is broken or a bug. Drilling down should actually be a drill down. I'll have to see if I can replicate your issue, I do not usually use stacked charts. I have had success with non-stacked charts having drilldown work properly. Are you on the latest release (January) of Desktop?

fchukoskie's avatar
fchukoskie
Icon for Advocate I rankAdvocate I
10 years ago

I'd expect to see the breakdown by Subject where Rating = 1 and Answer = 'It's not helping me'.

greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

That's currently not supported behavior. You'd have to take two steps:

  1. Drill down on [Rating] = 1
  2. Apply filter to [Answer] = "It's not helping me"

I know of no way to combine those into a single step in Power BI.