Forum Discussion
Display lowest Hierarchy slicer field selected
Anonymous
May be.. something like this.
Checking if the lowest level is filtered>>then next upper level>>then next
See the attached sample file as well
Measure = SWITCH ( TRUE (), ISFILTERED ( Table1[Level3] ), CONCATENATEX ( VALUES ( Table1[Level3] ), [Level3], "," ), ISFILTERED ( Table1[Level2] ), CONCATENATEX ( VALUES ( Table1[Level2] ), [Level2], "," ), ISFILTERED ( Table1[Level1] ), CONCATENATEX ( VALUES ( Table1[Level1] ), [Level1], "," ) )Anonymous
I see that order of levels 2 and 3 in your MEASURE was not correct.
Use this MEASURE
Selectedslicer = SWITCH ( TRUE (), ISFILTERED ( FACT_UTE[Employee] ), SELECTEDVALUE ( FACT_UTE[Employee] ), ISFILTERED ( FACT_UTE[SG_Code] ), SELECTEDVALUE ( FACT_UTE[SG_Code] ), ISFILTERED ( FACT_UTE[OC] ), SELECTEDVALUE ( FACT_UTE[OC] ), ISFILTERED ( FACT_UTE[Region] ), SELECTEDVALUE ( FACT_UTE[Region] ), "Select a value" )
Hi Zubair_Muhammad ,
I tried your formula and tweaked it, I came up with a problem.
it works when I select region, and the following hierarchy but when I select 20014 it doesn't appear, but when I select employee it does appear
Community ChampionAnonymous
Could you share your file?
Did you include all four levels in the formula?
Yes I included all the levels
I will share you the file now, I can't share files right now because I am still new but here is the access to the google drive I saved it in
https://drive.google.com/file/d/1WzIcG_ouKfWHKp3s6eotE99-GKgvrofm/view?usp=sharing
- Zubair_Muhammad
Anonymous
I see that order of levels 2 and 3 in your MEASURE was not correct.
Use this MEASURE
Selectedslicer = SWITCH ( TRUE (), ISFILTERED ( FACT_UTE[Employee] ), SELECTEDVALUE ( FACT_UTE[Employee] ), ISFILTERED ( FACT_UTE[SG_Code] ), SELECTEDVALUE ( FACT_UTE[SG_Code] ), ISFILTERED ( FACT_UTE[OC] ), SELECTEDVALUE ( FACT_UTE[OC] ), ISFILTERED ( FACT_UTE[Region] ), SELECTEDVALUE ( FACT_UTE[Region] ), "Select a value" )Wow! Thank you so much Zubair_Muhammad you're a life saver, it worked great I failed to see my mistake thank you!