Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jamesmathew
Helper I
Helper I

Display Selected Filter for the Hierarchy Slicer

Hello Community,
I am using a hirerarchy slicer to filter the values. Now I want to display the selection as a text.

In the below figure if I select foodservice segment it should display the same(but here it is displaying the First of Description).Is there any measure we can write to dispaly the selected Hirerarchy

mock.PNG

Attaching the reference pbix file https://1drv.ms/u/s!AlTyyZ_9D_WjiWLmwbAGdI66CkRd

3 REPLIES 3
Jamesmathew
Helper I
Helper I

Does any one know how to solve this?

 

Thanks

Anonymous
Not applicable

am not sure if this helps for Hierarchy Slicer:

 

https://www.youtube.com/watch?v=QYbl4k_CWBE

Anonymous
Not applicable

Location Selected = SWITCH(TRUE(),
          ISFILTERED(Level4), CONCATENATEX(VALUES(Level4),[Level4] ,", "), //Give a space after comma to make it readable
          ISFILTERED(Level3),CONCATENATEX(VALUES(Level3),[Level3],", "),
          ISFILTERED(Level2), CONCATENATEX(VALUES(Level2),[Level4],", "),
         ISFILTERED(Level1), CONCATENATEX(VALUES(Level1]),[Level1],"
                                       "), // if you want values in new line, then Shift + enter
        "All Selected")
-- But it always displays lowest level in the Hierarchy.

 

If you do not want to display these many items in the Card, then use below:

Location Selected = SWITCH(TRUE(),
                       ISFILTERED(vw_Court_Unit_Dim_BI[Site]),IF(COUNT(Level4)<4
                                              , CONCATENATEX(VALUES(Level4),[Level4],", ")
                                              , MIN(Level4]) & " and other " & COUNT(Level4)-1 & " Other Site(s) Selected"),
                      ISFILTERED(vw_Court_Unit_Dim_BI[Division]),CONCATENATEX(VALUES(vw_Court_Unit_Dim_BI[Division]),[Division],", "),
                     ISFILTERED(vw_Court_Unit_Dim_BI[County]), CONCATENATEX(VALUES(vw_Court_Unit_Dim_BI[County]),[County],", "),
                      ISFILTERED(Districts[Location]),CONCATENATEX(VALUES(Districts[Location]),[Location],"
                   "), 
"All Selected")

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.