Forum Discussion
Date-Time on X-Axis with Shift Pattern
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.
2 Replies
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
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.
