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.
Hi,
I'm trying to filter the date field to include the following only:
1. Today's date, and
2. All past dates before today's date, and
3. +10 days (into the future) after today's date
So the basis of the dynamic update will be always based on today's date.
Note: I'm using Direct Query as storage mode.
Relative date filtering does not have the option to filter get the all the dates as per my criteria above. Appreciate if you can help me with my request.
Best regards,
Mark
Solved! Go to Solution.
Hi @markefrody
Do you want the date filtered in a visual, slicer, or a calculation?
Based on my knowledge, there is no slicer to achieve this goal directly.
As a workaround, i create a measure, then add this measure in the visual level filter.
Measure = IF(MAX(Sheet5[date])<=TODAY()+10,1,0)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @markefrody
Do you want the date filtered in a visual, slicer, or a calculation?
Based on my knowledge, there is no slicer to achieve this goal directly.
As a workaround, i create a measure, then add this measure in the visual level filter.
Measure = IF(MAX(Sheet5[date])<=TODAY()+10,1,0)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The answer in #2 works when the data is not summarized (e.g. in a table), but does not work on other visuals when the data is summarized. For example, when the data is in a bar chart, column chart, or card, it shows the total number of results (42). Is there a way to modify the measure so that it works when the data is summarized?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |