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.

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
Icon for Community Support rankCommunity 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