Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Fake date

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)?

Dataflow
Need Help

3 Replies

  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    Resident Rockstar
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        v-kkf-msft
        Community Support
        4 years ago

        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