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 have two tables that have a common department number
Table 1 Table 2
Dept. Total Dept. Total
A 1 A 3
B 2 C 5
C 3
Table 2 does not have all of the departments shown in Table 1.
What I would like to do is show a bar chart of the with the values to table 1 and table 2 side by side
Chart
1 3 3 5
A B
however, whenever I link the tables together I get the correct value for Table 1 but the total for table 2
Linked Table
1 2
A 1 8
B 2 8
C 3 8
How do I reflect the right totals for Table 2?
I am expecting something like:
1 2
A 1 3
B 2
C 3 5
Any help is appreciated!
HD
Solved! Go to Solution.
Hi holydragon,
You may merge table1 and table2 first, click query editor-> merge.
Then delete Table2.Dept. , the result is like below:
Regards,
Jimmy Tao
Hi holydragon,
You may merge table1 and table2 first, click query editor-> merge.
Then delete Table2.Dept. , the result is like below:
Regards,
Jimmy Tao
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |