topic Singe Select Slicer with Select All in DAX Commands and Tips

Singe Select Slicer with Select All

ExcelMonke — Thu, 09 Nov 2023 18:14:18 GMT

I have a large data table with a column that returns two values based on an IF statement.

IF true THEN "Default"
ELSE "Not Default"

What I would like to do is to create a slicer that on a single click:

Filters to all "Default" values
Return all values are returned that are both "Default" AND "Not Default"

I've been playing around with Switch and IF functions and am not able to figure this one out. Any help is appreciated!

Re: Singe Select Slicer with Select All

FreemanZ — Fri, 10 Nov 2023 03:42:44 GMT

hi ExcelMonke ,

For a slicer, selecting no item is the same as selecting every item.

If this is not relevant, could you elaborate your expectation, ideally with dataset and corresponding expected result?

Re: Singe Select Slicer with Select All

Anonymous — Tue, 14 Nov 2023 07:36:20 GMT

Hi ExcelMonke ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.

(2)We can create a slicer table.

Slicer = DATATABLE ( "Column1", STRING, { { "default" }, { "all" } } )

(3) We can create a measure and put it to the visual filter.

Flag = IF ( ISFILTERED ( 'Slicer'[Column1] ), IF ( OR ( SELECTEDVALUE ( 'Slicer'[Column1] ) = "default" && SELECTEDVALUE ( 'Table'[Column2] ) = "default", SELECTEDVALUE ( 'Slicer'[Column1] ) = "all" ), 1, 0 ), 1 )

(4) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Re: Singe Select Slicer with Select All

ExcelMonke — Tue, 14 Nov 2023 15:40:47 GMT

Thank you. Do you add the DATATABLE slicer as a measure or a new column?

Re: Singe Select Slicer with Select All

Anonymous — Wed, 15 Nov 2023 01:31:14 GMT

Hi ExcelMonke ,

It is as a slicer table.

The [column1] field of this table is then used as a slicer. Or you can create the slicer table manually by clicking enter data in the home tab.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.