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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wildande
Frequent Visitor

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 with specific time. Is it something that's possible to do in Power BI?

 

Thanks in advance!

3 REPLIES 3
lbendlin
Super User
Super User

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.

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.

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. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors