Need help in DAX in Line Chart

[BalaKiran_M]

Experts, please help me on DAX column for sorting the current year & previous year.

The scenario is, we have one date column which holds the data for last 365 days and we have a requirement to show 2 lines on the Y-Axix i.e. one is for current year & previous year for comparing both year values. But, unfortunatley when we see on the current date it it is broken the line for previous year. please help?

[andhiii079845]

I find a solution perhaps but your data is more the probem:

How you want to show the value from last year when your data are missing there?!
Example: 01.02.2023 -> 01.02.2022 but your mininum Date in 2022 ist 02.03.2022!
THIS DO NOT WORK ! 🙂 
Possible is something like this. To bring both line together is not possible of missing data!

[andhiii079845]

Without the sample data and .pbix i have no idea what is the problem.

[BalaKiran_M]

Experts, please help me on this. The dark blue line in breaking due to there is no value populated in the date column i.e 03/01/2022 which causes the breaking. please suggest?

[BalaKiran_M]

I am ready to upload the .pbix file, please guide me to upload the file.

[andhiii079845]

upload it via the common upload services. if you have no sensitive data in the pbix

[BalaKiran_M]

@andhiii079845 I am really not sure where to upload it, kindly help me to navigate to upload it.

[andhiii079845]

you have to us a external service. like dropbox, wetransfer etc.

[BalaKiran_M]

@andhiii079845 Here is the link for the pbix file,

https://drive.google.com/file/d/1T2z2-Rul_G5VgMeEcYsMz8DCEVtfIpjl/view?usp=drivesdk

[andhiii079845]

I see the problem. You want to compate both years, right? 
You can not us than the regular date field MM/DD/YYYY. and also as a legend the year flag.
If you want to compare both years, i can fix it. 🙂

[BalaKiran_M]

Yes @andhiii079845 please help on this. I didn't get any resolution sofar on this, please help tp compare both years with the given dates.

Thanks,

Bala

[andhiii079845]

I can not open the old .pbi again in the moment.
One way: You can create a new column only for MM/DD not YYYY/MM/DD(!) and one column for year YYYY. Put MM/DD in the x-axis and YYYY in the legend.  Then you are able to see both lines for the years. 

[BalaKiran_M]

@andhiii079845 tried your suggestion, but it is not showing as two lines separately. Also, sharing my latest file via Google drive. please help.

https://drive.google.com/drive/folders/1SwL4aqyUClmRGOtnraHit_5EzGxD7aBb?usp=sharing

[andhiii079845]

It not easy. I see know the problem. I have to think about.

[BalaKiran_M]

@amitchandak sir please help

[andhiii079845]

For me is not 100 % clear how you create this vertical line. Can you explain it, please? 

[BalaKiran_M]

That's just a mouse hoverover to show the points is broken for the last year.