Relationship issue

[Anonymous]

I'm haveing a problem setting up a relationship between two tables. I want to show total shipments by hour with zero on the row if there are no shipments in that hour.

I created a table with just the hours 0 - 23 and linked it with a One to Many relationship to the Hours column in the shipping data. However, the Manage Relationship saves it as a Many to One link from the shipping data to the hours table giving me this with the hourly totals minus the hour rows with zero activity.

Formatted_Hour Orders Volume
0:00 8 10471
2:00 14 11074
3:00 5 6310
4:00 2 9696
5:00 8 4158
6:00 14 7278

[parry2k]

@Anonymous sorry your question is not clear, can you share relationship diagram and also what is not working and what you expected the result to be.

[Anonymous · Accepted solution]

It turns out it was working as needed all along. I was working on another part of the Power BI form and right clicked on the Hours table I'm using to drive the report and noticed an option "Show items with no data". When I enabled that for the Hours field in my visual - voila it displayed the data as I wanted.

[Icey]

Hi @Anonymous ,

Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

Best Regards,

Icey