Forum Discussion

LP280388's avatar
LP280388
Icon for Resolver II rankResolver II
4 years ago

How to get selected value from a Hierarchy Slicer

Hi Team,   Need a help in fetching the selected value from a hierarchy slicer. For example : I have the data as below.   I need to show the max hierarchy selected.  In the second image below, abc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Create index column in your table for Employees.

 

then use the below dax to get desired output.

 

Selected Value = 
VAR MAXIndex = CALCULATE(MAX(Sampl[Index]),ALLSELECTED(Sampl))
RETURN
IF(MAX(Sampl[Index]) = MAXIndex, MAX(Sampl[Emp]))

 

Do accept the solution if it fulfills your need.

 

Thanks,

Mohan V.

LP280388's avatar
LP280388
Icon for Resolver II rankResolver II
4 years ago

Anonymous Thanks for the response.

 

I created the index column and added the measure. but it gives the wrong name.  Could you please let me know the index should be on Employee ID?  its not giving right answer.

Also, the hierarchy slicer has Manager Name and Manager's Manager name as Level2 and Level1.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

     LP280388 Share your sample pbix file

    Yes you should create index on based on Emp.

     

     

     

    • LP280388's avatar
      LP280388
      Icon for Resolver II rankResolver II
      4 years ago

      Anonymous Thanks for the detailed response. 

      In the below, it should show selected value as abc4, abc5, abc2, abc3

       

      In the below it should show, abc2 as selected value

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        LP280388 it would be better that you provide detailed information about what you are looking for.

         

        The ask you mentioned in question can be solvable by the given solution.

        Provide more details regarding the above image output that you are looking for.