topic Re: DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year in DAX Commands and Tips

DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year

jcary02 — Fri, 03 Jul 2020 21:13:00 GMT

I'd like to reproduce a graph similar to the second one shown below in Power BI. I have measures for the current year and sameday last year. I'm having trouble projecting my last year measure into the future.

Basically, I want to show the same period last year for a future date. I have the data just can't get it to overlay. Any advise would be awesome!

This is an example of what I have so far in Power BI:

What I want to acheive is shown below. The blue line is the current year which ends today. the gray line is same period last year for but for a future date:

Re: DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year

lbendlin — Fri, 03 Jul 2020 21:45:54 GMT

put the date from the dates table (not the facts table) on the x axis and then select "show items with no data".

Re: DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year

jcary02 — Fri, 03 Jul 2020 21:52:23 GMT

Ok, I have the date from my dimension table on the x axis. Where can I find the 'show items with no data' option?

Re: DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year

lbendlin — Fri, 03 Jul 2020 21:53:33 GMT

click the triangle next to the date field in the visual's axis section

Re: DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year

jcary02 — Fri, 03 Jul 2020 22:07:18 GMT

Shoot, that didn't work. My date dimension goes until 2025, but when I select the 'show item with no data' option nothing changes.

Re: DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year

lbendlin — Fri, 03 Jul 2020 22:17:21 GMT

sorry I meant "put the date from the dates table minus the year component on the x axis". Calculated column is enough.

you need to strip the year from the date column, and then use the year as legend (the way you already did)

Re: DAX help: Show Sales YOY, but show the current year overlaid on the entire previous year

jcary02 — Fri, 03 Jul 2020 22:50:35 GMT

Thank you! Got it!