Comparison Chart

[Pursuit01]

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!

[vanessafvg · Accepted solution]

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.

[Pursuit01]

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!