Forum Discussion

wildande's avatar
wildande
Frequent Visitor
2 years ago

Set Visual to Specific Date and Time

Hi there,   I've been trying to get a solution for this to no avail. So I need to display visual from yesterday's date at 6:30 am to today's date at 6:30 am - So essentially 24-hour format but wit...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Certainly. However :

 

- you will need to decide what "today's date"  and "6:30am"  means. Remember that the Power BI Service runs on UTC and your users may sit in many different timezones.

- this requires an import mode data source with (at least) daily refresh.

  • wildande's avatar
    wildande
    Frequent Visitor
    2 years ago

    Hi lbendlin 

    Thanks so much for your time to reply back. I don't quite understand what you mean by import mode data source. Could you enlighten me on that? 

     

    My Data Sources are coming from compilation of Excel and Text files, which I get with Get Folder directly into my Power BI.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Yes, those are examples of import mode data sources.  Data changes will not reflect in your report until you actively refresh the dataset (ad-hoc or via schedule).

       

      In contrast, with a Direct Query data source   changes in the data will show as soon as the report user interacts with the visuals. No refresh required.