cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rmcmun
Frequent Visitor

Set range of x-axis to today (24 hours)

Hi all,

 

I have a data set of production volumes by time produced and production line. E.g., see today's output:

Screenshot 2021-01-22 at 19.35.49.png

 

I am trying to create a clustered column chart showing these values for the last 24 hours. I am able to filter the chart so that it only displays today's data, however I don't know how to set the x-axis so that it always displays the full 24 hour range. I.e., at the moment, the x-axis range is set by the range of the data:

Screenshot 2021-01-22 at 19.33.37.png

 

Is it possible to force the x-axis range to be the full 24 hours?

 

Thanks!

1 REPLY 1
parry2k
Super User III
Super User III

@rmcmun you should split your date and time column and have another dimension in hour model for 24 hours, and have a relationship with your main table, and on x-axis use time from this new time dimension and x-axis time column, in the drop-down, select "show items with no data", so it will give you all 24 hours. So there is a bit of modelling work you need to do.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.