Forum Discussion

jtooke's avatar
jtooke
Helper I
7 months ago
Solved

Slicer and Visualization Hierarchy

Hi, I have a data set with a Region - SubRegion - Country hierarchy, with a slicer and visualizations using all 3 levels. My standard view shows all by Region with users being able to drill to lower...
Need Help
  • danextian's avatar
    danextian
    7 months ago

    Hi jtooke 

    This will require a disconnected table and another measure referencencing such. There are only two levels in the hierarchy below but notice that whenever a district is selected (level 1), the column chart automatically shows all schools within that district within the need to drilldown.

     

    Please see the attached pbix.

lbendlin's avatar
lbendlin
Super User
7 months ago

In hierarchical visuals you can choose between Expand (showing the next level in addition to the current level) and drilldown (replacing the level with the next level).  

 

 

 

 

jtooke's avatar
jtooke
Helper I
7 months ago

Thanks lbendlin - maybe I can clarify what I am looking for. I am looking to avoid the need for a user to drilldown at all - for instance in my Region - SubRegion - Country hierarchy slicer, when a user selects something from Region, I want the visualization to automatically update to show SubRegions under that Region. When a user selects a SubRegion in the slicer, i want the visualization to automatically update to show Countries under that SubRegion. And the visualization's default view should show the Region. 

  • lbendlin's avatar
    lbendlin
    Super User
    7 months ago
    when they make a selection

    That is not something you can reliably probe.  Remember that in Power BI "nothing selected"  is the same as "everything selected"  and that you also need to distinguish between "selected","filtered", and "highlighted".

     

    Educating your users on how to use these arrows is the better option in my opinion.