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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

YTD Linear Chart

Hi All

 

I am trying to build a daily line chart to compare YOY betwen YTD FY21 and YTD FY22.

 

FY21 consist of all actual sales while FY22 consist of partial actual sales and forecast numbers. Both actuals and forecast are in different tables.

 

As you can see below, i tried to compare the sales in same day/month in different year but due to unique dates in both years (eg: 18th Aug 2020 and 18th Aug 2021), the line charts cannot be presented in an overlay manner.

 

I also tried to pull in Month-Day in X-Axis instead of date but the whole calculation will run and become incorrect. Below are my functions:

 

YTD FY21 = TOTALYTD([Actual FY21],'Calendar'[Date],"1/31")
YTD FY22 Team Commit = TOTALYTD([Forecast Team Commit],'Calendar'[Date],"01/31")
YTD FY21 % = DIVIDE([YTD FY21],[Grand Total Actual FY21])
YTD FY22 % = DIVIDE([YTD FY22 Team Commit],[Grand Total Team Commit Forecast FY22])

 

would really appreciate if somene can advise! thank you!

 

Spacewalker_0-1629276521304.png

 

 

4 REPLIES 4
Anonymous
Not applicable

Here's everything you need to do CORRECT calculations on a custom financial calendar:

Custom time-related calculations – DAX Patterns

Anonymous
Not applicable

Hi @Anonymous 

 

Thanks for your reply.

 

Are you saying that my functions are wrong which are causing the issue whereby I cannot present the YOY on month/day in X-axis?

 

I just want the two years YTD trend to show together above/under each other for the purpose of comparison. Is there a workaround for this please?

 

Thank you.

Anonymous
Not applicable

@Anonymous 

 

All I'm saying is that you should do things RIGHT and never try to re-invent the wheel. Please follow Best Practices of the field and you'll be safe.

Anonymous
Not applicable

Hi @Anonymous 

 

Thank you! I will explore the link that you have shared and hopefully will find a solution from there.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.