I have two tables with same column Names. I need to compare both data on line chart

[Anonymous]

I have two tables with same column Names storing day to day enrollment data. I need to compare both the tables erollment day to day enrollment on a single line chart.

In two tables two date columns are there for enrollment date. How to show on AXIS the dates. This is possible in Power BI?

 i need to show line chart for erollment count day wise. 

[v-easonf-msft]

Hi, @Anonymous 

You can consider creating a calendar table and establishing a one-to-many relationship with other tables based on the date field.Then you can use the date in the calendar table as the x axis.

Best Regards,
Community Support Team _ Eason