Chart formatting issues

[MrCrow]

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?

[parry2k]

@MrCrow did you selected show items with no data?

[parry2k]

@MrCrow check page 2 in the attached pbix file, you used the wrong columns in the relationship between the time dimension and fact table.

[MrCrow]

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

[parry2k]

@MrCrow sorry sharing the file has not worked. Can you take a look and reshare it?

[MrCrow]

https://drive.google.com/file/d/1XatgCKymD0uJTAspiXWf3zBkSEmf8d9y/view?usp=sharing

[parry2k]

@MrCrow using one/google drive 🙂

[MrCrow]

https://drive.google.com/file/d/1XatgCKymD0uJTAspiXWf3zBkSEmf8d9y/view?usp=share_link

[MrCrow]

@parry2k Not sure if the share worked.   But, clearing out the function of the min max x-axis range worked.   But like i feared it wont let me set the min range to 1am and the max to midnight.   Any ideas?

[parry2k]

@MrCrow there is something else going on, is there a way to share the pbix file, and remove sensitive information before sharing. 

[MrCrow]

Not sure how to share the file lol

[parry2k]

@MrCrow check this blog post Show items with no data in Power BI - Power BI | Microsoft Learn

[MrCrow]

Thanks!   But no dice

[parry2k]

@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]

Thanks!   Where exactly is that option?

[MrCrow]

@parry2k Something interesting i just found.   Was filtering by hour times while adding a card, and it is showing data for the earlier times.   But its just not visable.  Its almost like the whole table is shifted to the left.