Date-Time on X-Axis with Shift Pattern

[PowerBI-Newbie]

I am trying to recreate the following visualisation:

I need to create line graphs (it will be showing the median values) with the ability for the user to switch between the following (using bookmarks):

• Range graph - user is able to select between two date ranges
• 60-Minute graph (like the above graph) - user should only be able to select one day's worth of data and the 60 min intervals are shown on the x-axis along with the shift details, and the selected date being able to be added to the title of the graph.

Furthermore, there is a shift pattern and the start time is 4am to 4am and not midnight to midnight - so whatever date ranges are selected it'll be taking the shift pattern into account.

Any help is greatly appreciated, with or without .pbix file.

[Anonymous]

Hi @PowerBI-Newbie ,

Please follow the steps below to get it:

1. Create a line chart with special hour period as below screenshot

2. Create bookmarks to control the display of different visuals(hour range graph and 60-minute graph) in the same place

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

How to toggle visuals on and off in Power BI Reports 

Toggling Views with Bookmarks in Power BI 

Best Regards

[PowerBI-Newbie]

Hi @Anonymous, thank you for getting back to me.

What do you mean by special hour period?

If it's also possible to have the zoom slider on the x-axis for the user to move from date range to a specific time period that would be amazing.