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.

Kedar_Pande's avatar
Kedar_Pande
Super User
7 months ago

jtooke 

 

Yes. Field Parameter + Level measure.

Field Parameter: Region → SubRegion → Country hierarchy slicer.

 

Measures:

Level = SWITCH(TRUE(),  HASONEVALUE(Region), 1,  HASONEVALUE(SubRegion), 2,  3)

 

Children = VAR L = [Level]
RETURN SWITCH(L, 1, Region = SELECTEDVALUE(Region),
2, SubRegion = SELECTEDVALUE(SubRegion),
TRUE())

 

Visual filter: [Children] = TRUE

 

If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande