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.
Hello everyone.
Probably simple solution but I'm struggling with getting dates outside slicer selection.
I've got one table showing slicer's dates, but I need another one with extended dates.
For instatnce:
I've one week chooosen from slicer.
In the 2nd table I need to display week before, selected week and next week dates.
How should I deal with that?
Solved! Go to Solution.
@cienkibp
If I understood your question correctly, you need to have an additional dates table to have the desired result. Create a measure to filter the Extended table Viz as follows:
ExtendedDateFiter =
VAR __DATEMIN = MIN('Dates'[Date])
VAR __DATEMAX = MAX('Dates'[Date])
VAR __DATEEXT = SELECTEDVALUE('Dates Extended'[Date])
VAR __RESULT =
INT(
__DATEEXT >= __DATEMIN - 7 &&
__DATEEXT <= __DATEMAX + 7
)
RETURN
__RESULT
File is attached.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@cienkibp
If I understood your question correctly, you need to have an additional dates table to have the desired result. Create a measure to filter the Extended table Viz as follows:
ExtendedDateFiter =
VAR __DATEMIN = MIN('Dates'[Date])
VAR __DATEMAX = MAX('Dates'[Date])
VAR __DATEEXT = SELECTEDVALUE('Dates Extended'[Date])
VAR __RESULT =
INT(
__DATEEXT >= __DATEMIN - 7 &&
__DATEEXT <= __DATEMAX + 7
)
RETURN
__RESULT
File is attached.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |