Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Euro0681
Helper II
Helper II

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 first slicer it filters the second slicer and cannot display me a value.

Euro0681_0-1671574838139.png

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

Euro0681_1-1671574888306.png

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 5
FreemanZ
Super User
Super 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
Super User
Super 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. 

v-rongtiep-msft
Community Support
Community Support

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.

 

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)

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors