Forum Discussion
Comparison Chart
Hi,
I have 2 summary tables that I imported to power bi desktop, below is an example of the data:
TABLE A:
| ID | ALLOC DATE | AMOUNT BILLED |
| 1 | 1/31/2021 | 15.50 |
| 2 | 2/25/2021 | 10.50 |
| 3 | 3/28/2021 | 20.75 |
TABLE B:
| ID | ALLOC DATE | AMOUNT PAID |
| 1 | 2/10/2021 | 15.50 |
| 2 | 3/15/2021 | 10.50 |
| 3 | 4/12/2021 | 20.75 |
Question:
I need assistance on what's the best way to visualize this data in a comparison chart?
Any assistance would highly be appreciated! Thank you!
what are you comparing against?
amount billed by year, month, day, something else?
the best way to model this date is to add a date table, and link both tables fromthe date table. then you can use the date information in the date table to slicer your data and compare values between the table.
2 Replies
- vanessafvg
Community Champion
what are you comparing against?
amount billed by year, month, day, something else?
the best way to model this date is to add a date table, and link both tables fromthe date table. then you can use the date information in the date table to slicer your data and compare values between the table.
Hi, vanessafvg Thank you for your response, yes, I'm trying to compare against the date; YoY/MoM.
I will link the 2 tables to a date dimension table in my model as you suggested. Thank you!
