Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
94 | |
91 | |
82 | |
69 |
User | Count |
---|---|
161 | |
127 | |
124 | |
108 | |
97 |