Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, do you have any idea how to set the date range to show the data for the last 1 week? The data would be shown for the last 7 days from today, data refresh every day.
Solved! Go to Solution.
Hi, @anand_kumar
I'd like to suggest you use relative date slicer or filter to display the result. I created data to reproduce your scenario.
Table:
Result:
For further information, please refer to the following document.
Creating a relative date slicer and filter in Power BI
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @anand_kumar
I'd like to suggest you use relative date slicer or filter to display the result. I created data to reproduce your scenario.
Table:
Result:
For further information, please refer to the following document.
Creating a relative date slicer and filter in Power BI
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@anand_kumar , You have to create a column like this and use
In last 7 days = if('Date'[Date]>=TODAY()-7 && 'Date'[Date]<=TODAY(),"Last 7 Days",[Date]&"")
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |