Forum Discussion

poojayadav22's avatar
poojayadav22
Advocate I
8 months ago
Solved

Need help for Ragged hierarchy for the default slicer with dropdown

i want to implemet ragged hierarchy in slicer because i have to show drowpdown 

Default slicer

i have used isinscope function, have used below dax

location level =
VAR BrowseDepth =
    SWITCH(
        TRUE(),
        ISINSCOPE('Functional location'[Level 6 Id]), 6,
        ISINSCOPE('Functional location'[Level 5 Id]), 5,
        ISINSCOPE('Functional location'[Level 4 Id]), 4,
        ISINSCOPE('Functional location'[Level 3 Id]), 3,
        ISINSCOPE('Functional location'[Level 2 Id]), 2,
        ISINSCOPE('Functional location'[Level 1 Id]), 1,
        0
    )
 
VAR ThisLevelBlank =
    SWITCH(
        BrowseDepth,
        1, ISBLANK(SELECTEDVALUE('Functional location'[Level 1 Id])),
        2, ISBLANK(SELECTEDVALUE('Functional location'[Level 2 Id])),
        3, ISBLANK(SELECTEDVALUE('Functional location'[Level 3 Id])),
        4, ISBLANK(SELECTEDVALUE('Functional location'[Level 4 Id])),
        5, ISBLANK(SELECTEDVALUE('Functional location'[Level 5 Id])),
        6, ISBLANK(SELECTEDVALUE('Functional location'[Level 6 Id])),
        TRUE()
    )
 
RETURN IF(NOT ThisLevelBlank, 1, 0)
But the problem is that it is showing only one level 

community 
is there any way to fix it with the help od dax as i have used hierachyslicer but the problem with that it does not have dropdown option

 
 
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    8 months ago

    Hi poojayadav22,

     A normal Power BI slicer cannot display a ragged hierarchy with dropdown levels — it will always flatten the hierarchy and show only one field at a time, no matter what DAX you write.

     

    Alternatively you can use custom visuals, for e.g. AG-Grid (free version supports hierarchy tree dropdown) or OKViz Smart Filter Pro (paid).

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

     

    Ag Grid 

     

     

3 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    8 months ago

    Hi poojayadav22,

     A normal Power BI slicer cannot display a ragged hierarchy with dropdown levels — it will always flatten the hierarchy and show only one field at a time, no matter what DAX you write.

     

    Alternatively you can use custom visuals, for e.g. AG-Grid (free version supports hierarchy tree dropdown) or OKViz Smart Filter Pro (paid).

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

     

    Ag Grid 

     

     

  • v-venuppu's avatar
    v-venuppu
    Community Support
    8 months ago

    Hi poojayadav22 ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you grazitti_sapna  for the prompt response.

    I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    8 months ago

    Hi poojayadav22 ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.