Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Attaching the reference pbix file https://1drv.ms/u/s!AlTyyZ_9D_WjiWLmwbAGdI66CkRd
Does any one know how to solve this?
Thanks
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")
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |