Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |