Forum Discussion
Helper IISelecting 2 Values from slicer
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])
5 Replies
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.
Euro0681The 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)
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.
FreemanZSuper User
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.
- FreemanZ
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.
