Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi community!
I have a visual that shows a sum of rows grouped by hour and filtered by only showing the last day.
Since one production 'day' is not from 00:00 to 00:00 but starts at 06:00 and ends at 06:00, I want the X-axis to represent that.
Both Y-axis lines are from different tables, both have a relationship to the same date dimension and time dimension tables.
Any ideas how to tackle this? Let me know what more info is needed!
Thanks in advance,
Hi @PVosESKA ,
I am not positive as to the visual that you are using but you should be able to go to the Visualizations column and adjust the Max and Min for the range:
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @collinq ,
Thank you for your response, I'm using a 'simple' line chart.
My Y-axis is showing the count of rows, X-axis is showing hour 00:00 - 23:00
I would still need all the hours though, just a different starting and ending point, on top of that it would display 2 days instead of 1 (january 1st 06:00 - january 2nd 06:00).