Forum Discussion
Comparing two tables vertically and display the difference
I have two datasets, one with projected numbers and one with actual numbers. The team requested for a dashboard to be built to compare the two but stacked vertically and with the differences displayed beneath.
Some thing like the screenshot below.
I'm able to join the two datasets together with based on the Selection column values but can only seem to figure out how to display the values and differences side by side rather than vertically. Is there a way to do this in Power BI?
Hi qazz12
You can achieve this layout using disconnected table of all variations of
Categories + projection and actual and dynamic measure.
The logic is very similar to p&l statements.
For more information please refer to the linked tutorial:
https://www.youtube.com/watch?v=SH4UX4fGU9A&t=1226sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
1 Reply
Hi qazz12
You can achieve this layout using disconnected table of all variations of
Categories + projection and actual and dynamic measure.
The logic is very similar to p&l statements.
For more information please refer to the linked tutorial:
https://www.youtube.com/watch?v=SH4UX4fGU9A&t=1226sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.