Forum Discussion
Show All Values on Many-To-Many Line and Stacked Column Chart
Hello,
I'm trying to create a Line and Stacked Column chart that shows data from two different tables.
The value from one table is Hours, and it's for the Line value. The other values are Beginning Past Due and Booked, which are the Column values. The axis is Week Number, which both tables have, and have a Many-To-Many relationship with.
The Column values are appearing correctly on the chart, but the Hours are not. There is an amount for Hours for every Week Number, while there isn't for the Column values. I'm assuming it's only showing the Hours that are tied to the Column values that have values per week number. (For example, Week #4 doesn't have a column value, so it doesn't show the Hours value that is associated with Week #4.)
I have 'Show items with no data' selected for the Shared axis, and that isn't working.
Should I create a relationship table for my two tables to associate the Week Number to one column? Is there something I'm missing?
Here's an image of what I have so far:
3 Replies
Not very clear. Can you share data model, source data and expected output
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Data:
Week Number Beginning Past Due Booked Hours 1 14 0 37 2 0 0 28 3 2.7 0 37 4 0 0 37 5 1 0 37 6 0 0 30 7 0 0 28 8 0 0 37 It's showing:
Week Number Beginning Past Due Booked Hours 1 14 0 37 2 0 0 3 2.7 0 37 4 0 0 5 1 0 37 6 0 0 7 0 0 8 0 0 (Not showing all the Hours unless there is a booked or beginning past due value). I expect it to show all of the data on the graph.
Database:
Work Center Data Week Number example:
Week Number Booked Beginning Past Due 1 0 14 3 0 2.7 5 0 1 9 10 0 10 2 0 11 2 0 12 1 0 (Table doesn't have Week Number rows for when it doesn't have a value associated to that Week Number ex. 2, 4, 6-8, ... are missing)
Throughput Plan Week Number example:
Week Number Hours 1 9.25 1 9.25 1 9.25 1 9.25 2 7 2 7 2 7 (The graph should add up all of the hours to = 37, 28, ...) But it's missing the ones that are missing from the Work Center Data table.
