Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

ERROR TOtal Sale TY and LY ,

Hi , 

 

i still get confusing , When i visualize between TY and LY the line is not overlapped. 
it shown the continous , even i chnge the X to Categoral , it keeps appear like this. I found my past reports look the same but the visualization on these calculation looks fine. 
i also get confusing over this , sometimes i get it fix , sometimes i don't . and the calculation i used for last year shown 2019. it should be 2017 , not 2017. i dunn have data in 2019. 

 

1.PNG

Status: Needs Info
Comments
v-yuezhe-msft
Employee

@Chanleakna123,

I am unable to reproduce this issue in Power BI Desktop August 2018 version.
1.PNG

Could you please share sample data of your table so that I can test? Also what is the version of your Power BI Desktop? If the max date of your fact table is 12/31/2017, the date of the x-axis in line chart should be 12/31/2018 after you put LY measure into Line chart.


Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Needs Info