Forum Discussion

Ashok_Gopeani's avatar
Ashok_Gopeani
Icon for Helper I rankHelper I
2 years ago
Solved

Display columns in Matrix visual based on selection in the hierarchy slicer

Hello Team,   we have one hierarchy slicer with country- state-district combination and matrix visual. Based on the selection in slicer the respective columns are going to add or display in matrix ...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Ashok_Gopeani 

    Please update the measure 

     

    selectHierarchy = SWITCH(
    TRUE(),
    ISFILTERED(Country[District]) || ISFILTERED(Country[State]),1,0)

     

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

Ashok_Gopeani's avatar
Ashok_Gopeani
Icon for Helper I rankHelper I
2 years ago

Hi Gayatri_D05 ,

 

i intionally keep that measure on matrix visual as it is dispaying all values if we keep slicer without selection. so we should keep some valid measure that should allow to dispaly columns in matrix whe we select the value in slicer only. and also matrix should display values on any sort of selection in slicer

Gayatri_D05's avatar
Gayatri_D05
Icon for Resolver II rankResolver II
2 years ago

Hi Ashok_Gopeani , Okay then i would suggest changing the logic of the measure. tahts the only thing holding the visual back.