Measure a column of numbers or blanks to create a slicer with yes or no

[AMaxfield]

Hi All

I have acolumn of data for stock demand whcih either has many number vlaues or blank cells.

I want to include a clicer in the report with just two options for either demand yes or no.

So basically where there is a blank it will be demand no and any number will be demand yes.

Can you please point me in the right direct how to set this up? Thanks Andy

[Thim · Accepted solution]

You can create a new Column with a Dax formula like this.

Blank Slicer = IF('Table'[Column1]=BLANK();"No";"Yes")

Then you can use the new column as a filter.

Hope this will help. 🙂

[AMaxfield]

Great thanks worked once I realised it was "New Column" rather than "New Measure"

[rajulshah · Accepted solution]

Hello @AMaxfield,

You can create a calculated column as below:
Demand Yes/No = IF(ISBLANK(Table[Stock Demand]),"No","Yes")

You can use this column in the slicer.

[Thim · Accepted solution]

You can create a new Column with a Dax formula like this.

Blank Slicer = IF('Table'[Column1]=BLANK();"No";"Yes")

Then you can use the new column as a filter.

Hope this will help. 🙂