topic Yes,no selection in slicer in DAX Commands and Tips

Yes,no selection in slicer

AMBP73 — Sat, 16 Sep 2023 07:42:12 GMT

Hello everyone.

I am trying to create a yes or no selection in a slicer based on a column that has two unique values and blanks.

Example

Ux, Ux/AIW = yes

Blanks =No

I have already created a new one column table with the values 'Yes' and ' no'. Could someone please assist with the correct SELECTEDVALUE measure.

Thankyou

Re: Yes,no selection in slicer

Mahesh0016 — Sat, 16 Sep 2023 10:04:49 GMT

AMBP73 I hope this helps you.
Yes/No=IF(

IS FILTERED(Table[ColumnName]),"Yes","No"
)

Re: Yes,no selection in slicer

AMBP73 — Tue, 19 Sep 2023 01:26:49 GMT

Thankyou Mahesh. I have created the measure, Could you please advise if this is applied to the filters, as it cannot be applied to the slicer directly?

Thanks in advance.