Forum Discussion
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
- amitchandak
Super User
Niharika , refer if this can help
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 🙂- Your requirements are not clear. Please refer to this:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best
D
- mahoneypat
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
