Forum Discussion

Euro0681's avatar
Euro0681
Helper II
3 years ago

Selecting 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 fi...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

 

Euro0681's avatar
Euro0681
Helper II
3 years ago

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.