Two Line Graph

[angeladavey]

I need to create a line graph with YoY comparison for the month of Jan, I'd like the lines to appear over the top of each other, but am only able to get this:

Any ideas of how to fix this, please?

Thanks in advance! 

[v-lionel-msft]

Hi @angeladavey ,

If you want the two lines to overlap, then your X axis can only have one dimension.

Best regards,
Lionel Chen

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

[amitchandak]

Make sure you have date table. and then use ytd , lytd . or date range and year behind measure

Example

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"12/31"))
This Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD((ENDOFYEAR('Date'[Date])),"12/31"))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Last YTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd(dateadd('Date'[Date],-1,Year),-21,Day))

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/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[Anonymous]

Put only Month in the Axis of the line visual instead of Date. 

[angeladavey]

Thank you 🙂

This then appears as two dots - I'd like a line representative of all the days in January - how would I go about this? Sorry for all the questions!

[Anonymous]

@angeladavey Could you share your data file please? Or share a screenshot if sensitive date? Much easier to descibe solutions if we can see the data?

[Anonymous]

Create a column in your date table with month + day value and put that in instead of month 🙂 Goodluck!

Should also be able with date hierarchy i believe, but im unable to test atm.