Forum Discussion

Joshua_'s avatar
Joshua_
Icon for Helper II rankHelper II
2 years ago
Solved

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

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

dropdown menu
Slicer
white
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

     

     

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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_'s avatar
      Joshua_
      Icon for Helper II rankHelper II
      1 year ago

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