Filter out blanks when the table is sliced

[Anonymous]

Hi,

I have a dataset as below:

I'm using the 'Description' column as a filter. When I filter it for any value, I want power bi to filter out blank cells from the 'Value' column and just show me cells with values.

Again when I remove the filter it should show me back all values including blank cells.

Is this something possible?

Thanks in advance for your time and help!.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

Add below measure into visual level filter and set its value to 0.

Measure value =
IF (
    CALCULATE ( ISFILTERED ( Sample3[Description] ), ALLSELECTED ( Sample3 ) ),
    IF ( SELECTEDVALUE ( Sample3[Value] ) = BLANK (), 1, 0 ),
    0
)

Best regards,

Yuliana Gu