Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Slicer dropdown to filter area data and hide rows in Matrix

Hello to all,

 

When using a slicer dropdown to filter data, let's consider a scenario where there are 5 Multi Areas (A, B, C, D, and E), each having 4 districts, resulting in a total of 20 districts in rows. If we filter for Multi Area A, the Matrix will display the values of the 4 districts belonging to Multi Area A, while the remaining districts will appear as blank cells.

 

However, hide the 14 remaining districs from the rows, but only display the 4 districts related to the selected Multi Area (A in this case). 

Visulazation type = Matrix 

 

I will have a Area slicer on the above of this below view and whenever i select any area it should give me distrcits related to the selected Area and rest all distrcts should be hidden.

 

 

 

Thanks a lot for the help.

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I created a workaround using this DAX and it solved my problem

    CF = IF(HASONEVALUE(Tab1[Dist]), BLANK(), 'Tab3'[M1])
     
    THANKS Anonymous  Anonymous  for the support.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Anonymous ,

     

    You can try it by following these steps

    1. Format – Row headers – Options – Stepped layout set off.

    2. Column subtotal and Row subtotals – set off.

    3. Place the fields into the matrix as follows.

    [Area] and [District] --  Rows

    [M1],[M2],[M3]and[M4] -- Value

    4. Result.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you Anonymous , but it did not worked for me,  i still get all the rows with/without the values in the matrix

     

    view is like this if I filter Area = A

    wanted to add that M1- M4 are calculated measures  

     

    VIEW I need.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hii Anonymous , I think a simple slicer should work in your scenario. If not can you please provide a pbix file without any confidential data.

    Thankyou.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Anonymous ,

     

    You could try turning off "Show items with no data".

    What formula do you use for your measure?

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I created a workaround using this DAX and it solved my problem

      CF = IF(HASONEVALUE(Tab1[Dist]), BLANK(), 'Tab3'[M1])
       
      THANKS Anonymous  Anonymous  for the support.