Fake date

[Anonymous]

I have a show case report that was built last year for a customer. 

I no longer have access to the live data (for obvious reasons) but would still like to show-case this report as a demo. 

However, the report is built using many relative date filters and formulas (DAX, M, and visual filters). So using the current date most of the report is broken. 

Is there a way to 'fake' the date the report serve ruses so I can manually tell PBI report service that it is 2021 (or any date I choose)?

[StefanoGrimaldi]

send an example of you dax formula to point out the way for you to have an idea, basically you need to replace any query or formula tha use internel dates like today() etc etc for hard parameters like 

calculate(sum(table 1[values]), year(today()) = table 1[year]) to something like

calculate(sum(table 1[values]), table 1[year] = "2021")

[Anonymous]

That's what I was fearing you'd say! 😀

Before I go down this route, there is no method you are aware of that I can force change the date on the server? 

[v-kkf-msft]

Hi @Anonymous ,

The Power BI server’s date and time is based on UTC, and Relative Date slicer filters data by the date relative to today’s date. So currently we can't change the current date in the Service. I think you have to modify your measures and date slicers in the way @StefanoGrimaldi does.

Please submit your ideas here.

https://ideas.powerbi.com/ideas/ 

Best Regards,
Winniz