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

Reply
Niharika
Regular Visitor

Is it possible to link two date range filter with the same table?

Hi, I'm trying to make my table columns dynamic. Can you please let me know if it is possible directly or using Dax? The scenario is like I want to add two date range on my page, there I am showing a table with the current value columns and the previous value columns. I want to dynamically change the alternate columns using the two filters respectively. That is like; using date range 1, columns 1 should only change, and using the 2nd date range column 2 will change and so on respectively.

4 REPLIES 4
mahoneypat
Microsoft Employee
Microsoft Employee

If I understand what you are trying to do correctly, the following approach might work.

 

1. Make two calculated DAX tables, both with the same expression - FilterDates1 = Values(OriginalTable[Date]) and same for FilterDates2

2. Add each of the new Date columns as slicers to your report

3. Write two measures like this - MeasureWithFilter1 = Calculate([MyMeasure], TREATAS(Values(FilterDates1[Date]), OriginalTable[Date]))

4. Add the two measures to your visual

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


amitchandak
Super User
Super User

Hi Amit,
Thanks, you take the time to give the response to my Query!
I am not looking for something like this, I want to filter my alternate columns using 2 slicers independently.
Although Thanks for the suggested video,  it added up to my learning 🙂

Anonymous
Not applicable

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.