Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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,
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,