Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
kostianius
Regular Visitor

Get data for the 7 days period in PowerBI web version correctly. Is it possible?

Hello, 

I am sorry if it is a wrong forum section (not sure about it) but please tell if there is any possibility to filter data for the last 7 dynamically in order do not to change the report everyday? I am currently using Day as a report filter with Top N -> Last 7 Day - Last Day option (please see attachment) but i am not sure that it is a good solution and that it show real data. and i can not chose last month and last year as well for permanent basis so as Web version does not support it.  Can not use PowerBi desktop so as our Azure Rest API can not provide me with last data (i suppose there will be only current data) but not future data (for example next days, months, years) and i will be forced to add it manually. And also in powerbi desktop version some fields are absent (cost for example) which are present in web version. As for me it is not very good and i do not want to waste my time on recreation of these fields. Thereby i believe that should be simple solution for web version to get the data for the last 7 days on daily basis. If you know how to do it please tell me. Thanks.

 

http://polariton.ad-l.ink/7yyhqPK6K/image.png

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@kostianius

 

For this kind of LAST X PERIOD scenario, you can add a column to tag the period, then UNION all LAST X PERIODS into one date period table. Then you can just put the tag column into a slicer for period selection. For more details, please see:

 

POWER BI – TIME PERIOD SLICER FOR LAST 7 DAYS,LAST 30 DAYS..

 

Regards,

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@kostianius

 

For this kind of LAST X PERIOD scenario, you can add a column to tag the period, then UNION all LAST X PERIODS into one date period table. Then you can just put the tag column into a slicer for period selection. For more details, please see:

 

POWER BI – TIME PERIOD SLICER FOR LAST 7 DAYS,LAST 30 DAYS..

 

Regards,

Thanks

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors