topic Re: Selecting 2 Values from slicer in DAX Commands and Tips

Selecting 2 Values from slicer

Euro0681 — Tue, 20 Dec 2022 22:25:05 GMT

I need to select 1 values from two seperate slicers, but the catch is that the slicer uses the same 'date' column from the table.
This poses a problem because whenever I select the value from the first slicer it filters the second slicer and cannot display me a value.

Works when the value is the same, of course but i need a functionality like below...

I'm wanting the measure to produce the value '2022-06', but due to the selection in the first filter it cannot is there any work arounds?
I know I can allow multiple selections and use one slicer but I want a limit of being able to select only 2 dates (and if i use multi select I can select More than 2)

Measure = MAX('Table'[Date])

Re: Selecting 2 Values from slicer

Anonymous — Wed, 21 Dec 2022 02:26:27 GMT

Hi Euro0681 ,

Please have a try.

measure = VAR _1 = SELECTEDVALUE ( date1[date 1] ) VAR _2 = SELECTEDVALUE ( date2[date 2] ) RETURN IF ( _1 > _2, _1, IF ( _2 > _1, _2, BLANK () ) )

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

Re: Selecting 2 Values from slicer

Euro0681 — Wed, 21 Dec 2022 02:31:19 GMT

The problem is the name is the same I just changed for clarification purposes. The column used for both slicers is 'Table'[date] so selected value of date wouldn't work (the names Date 1 and Date 2 are just names changed at the visual level)

Re: Selecting 2 Values from slicer

Anonymous — Wed, 21 Dec 2022 02:34:59 GMT

Hi Euro0681 ,

Create another table with date column. Otherwise, the same column of data cannot select different values in different slicers or obtain different values.

In my sample, there are different tables.

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

Re: Selecting 2 Values from slicer

FreemanZ — Wed, 21 Dec 2022 09:04:40 GMT

In case we need a slicer to define the date filter boudary, the slicer shall be based on an isolated date tables, no relation with other table, like a parameter table. Otherwise, we get single datepoint from the slicer, instead a date range.

Re: Selecting 2 Values from slicer

FreemanZ — Wed, 21 Dec 2022 09:04:45 GMT