Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Joshua_
Helper II
Helper II

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
Info.png


thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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]))

vbofengmsft_2-1728354520208.png

2\Create relation ship with Table and DIM_TIPO_PLATAFORMA_3

vbofengmsft_3-1728354553581.png

3\Add asilcer

vbofengmsft_4-1728354598546.png

4\Filter on NOMBRE4

vbofengmsft_5-1728354650439.png

 

Best Regards,

Bof

 

 

 

 

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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]))

vbofengmsft_2-1728354520208.png

2\Create relation ship with Table and DIM_TIPO_PLATAFORMA_3

vbofengmsft_3-1728354553581.png

3\Add asilcer

vbofengmsft_4-1728354598546.png

4\Filter on NOMBRE4

vbofengmsft_5-1728354650439.png

 

Best Regards,

Bof

 

 

 

 

 

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.