Hide white values ​​in slicer type object with dropdown menu.

[Joshua_]

hi guys, I have data from a table and I need to use it as filters in a slicer object with a drop-down menu. When entering data into the object, blank data appears.

I have used a measure that works perfectly for me in a matrix, I have tried to apply it to the object with a drop-down menu but it does not work.

Can it be done? I tried downloading new objects but none of them have helped me.

I attach my table, and the dax measure that I use in the matrix



thank you

[Anonymous · Accepted solution]

Hi @Joshua_ ,

I've made a test for your reference:

1\Create a new table (Table)

Table = DISTINCT(SELECTCOLUMNS(DIM_TIPO_PLATAFORMA_3,DIM_TIPO_PLATAFORMA_3[NOMBRE3]))

2\Create relation ship with Table and DIM_TIPO_PLATAFORMA_3

3\Add asilcer

4\Filter on NOMBRE4

Best Regards,

Bof

[Joshua_]

Hi @Anonymous 
Thank you very much, it worked perfectly for me, it is working.
Regards.