Forum Discussion
Chart formatting issues
Hey friends!
Trying to make a chart to show hourly load time averages, and since this is a daily update infographic report i want to keep the x axis the same every day. I have 2 issues, x axis is not starting at 1am like I would like, and there is a strage blank area to the right of the chart.
So, the data table has dock in with timestamps. The only way i thought i could keep the chart formatted from 1am to midnight was to make a seperate small table with just hour stamps. (did it this way in case there are days we dont actually have trucks that early or late in the day)
Data is loading to the chart just fine. But for some reason, there is the issue of the chart starting at 6am, and the big o gap to the right.
Anyone have an idea on what I am doing wrong? Or, do you have a better way of getting the result i am looking for?
15 Replies
MrCrow try to turn on "show items with no data" and see if that will get the result you are looking for. For any hour with no value, you will see every hour on the x-axis.
Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
MrCrow check this blog post Show items with no data in Power BI - Power BI | Microsoft Learn
Thanks! But no dice
Not sure how to share the file lol
Nice thanks! That helped. But, still doesnt solve the issue fully. Fixed the relationship, but the graph when filtered down to days that dont have load times early or late in the day the x axis wont stay at midnigh to midnight
