Slicer dropdown to filter area data and hide rows in Matrix

[Ohboy_991]

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.

[Anonymous]

Hi  @Ohboy_991 ,

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.

[Ohboy_991 · Accepted solution]

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

CF = IF(HASONEVALUE(Tab1[Dist]), BLANK(), 'Tab3'[M1])

THANKS @Anonymous  @punitkhatri  for the support.

[punitkhatri]

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

Thankyou.

[Ohboy_991]

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]

Hi  @Ohboy_991 ,

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.