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.
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:
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.
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
Not very clear. Can you share data model, source data and expected output
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |