Overlap two line charts

[Anonymous]

Hi!

I want to overlay one line graph on top of another to display cummukative values from two diffrent sources, is it possible to do so without any overlapping axis details clasing .  have values in my one axis and dates on other both from different sources.

SOurce 1 = Date 1 and Value 1

SOurce 2 = Date 2 and Value 2

How do I show both lines on either one chart with lines or two line charts overlaid on each other.

Help will be greatly appreciated.

Thanks

[v-xuding-msft]

Hi @Anonymous ,

Here are the similar threads that you could reference. If these can't help you, please share a dummy pbix file or some sample data and expected results. Then we will understand clearly.

https://community.powerbi.com/t5/Desktop/Merge-Overlay-two-line-charts/td-p/386525

https://community.powerbi.com/t5/Desktop/Overlay-Combine-Line-Charts/td-p/432441 

https://community.powerbi.com/t5/Desktop/Overlaying-Graphs/td-p/151041 

https://community.powerbi.com/t5/Desktop/How-to-merge-two-line-charts/td-p/715186 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Both should join with the same dimension and get plotted. Now if they are different table it should happen automatically. In case one table and two dates.

Refer to this file if there two tables: https://www.dropbox.com/s/bu47m5ek7sr9v8t/sales_analytics_v2.pbix?dl=0

For one table two dates: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[Greg_Deckler]

Would need sample data to be sure what exactly to do here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490