Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relationship issue

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

parry2k's avatar
parry2k
Super User
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Icey
    Community Support
    6 years ago

    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