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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Using selected date in slicer to filter dates in another table

I have two separate tables:

1. "From" date

2. "To" date

Both tables have identical list of dates but I would like to use both as them as separate slicers.

For Example, I have dates from 1/1/2019 till 20/1/2019.

If I selected 10/1/2019 in the "From" date slicer, I would like the "To" date slicer to only show the dates after 10/1/2019, which is the selected value in the "from" date slicer.

I have been searching the net for answers for a few days now and I hope someone can help me with this!

1 ACCEPTED SOLUTION
Employee

Hi @bcng,

Based on my test, you could refer to below steps:

Create a measure:

`Measure = IF(CALCULATE(MAX('To'[Date]))>=SELECTEDVALUE('From'[Date]),1,0)`

Set the visual slicer:

Result:

But the measure could not be applied it in the slicer, I suggest you use the measure in visual.

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User

So, typically the way you do that is to disconnect your slicers from everything using Edit Interactions. Then you create a measure that grabs the MAX or SELECTEDVALUE of each slicer and performs a calculation which returns a value if it is within that range or BLANK() or 0 otherwise and that essentially becomes your filter.

If that doesn't help, need more information to be more specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

Hi Greg,

I tried using this measure:

Measure = IF('To Date'[Current Historical]>=VALUES('From Date'[Current Historical]),'To Date'[Current Historical],BLANK())

but I am getting this error:
A single value for column 'Current Historical' in table 'To Date' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Can't seem to figure out how to work around this error.

I have already created a relationship between the two columns

Employee

Hi @bcng,

Based on my test, you could refer to below steps:

Create a measure:

`Measure = IF(CALCULATE(MAX('To'[Date]))>=SELECTEDVALUE('From'[Date]),1,0)`

Set the visual slicer:

Result:

But the measure could not be applied it in the slicer, I suggest you use the measure in visual.

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors