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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

YTD on the end of clusterd column chart (one chart)

Hello, team. 

 

I would like to know how can I put the YTD on the same chart of the other values. 

 

azauskis_1-1651764899577.png

 

I tried following these guidelines but it didn't work: Solved: Re: Weekly graph data and YTD data in one chart - Microsoft Power BI Community

 

Thank you in advance for your help 🙂

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello,
I got solve it! 🙂
Soon, i will post the solution. 
Thank you for your attention.

View solution in original post

3 REPLIES 3
Whitewater100
Solution Sage
Solution Sage

Hi:

If you have two separate measures (base and YTD) you can add to a chart(s). It's important to have a date table,marked as date table and with relationship to your fact table(table with data you are visualizing). There are more ways to do this and some people like using bookmark to give this flexibility. If interested in bookmark approach, there are many youtube videos on that. I hope this helps..

Whitewater100_0-1652274273654.png

Total Sales = SUM(Data[Sales])
YTD Sales = TOTALYTD([Total Sales], Dates[Date])
 
Whitewater100_1-1652274368508.png

 

Anonymous
Not applicable

Hello,
I got solve it! 🙂
Soon, i will post the solution. 
Thank you for your attention.

tamerj1
Super User
Super User

Hi @Anonymous 

can you share sample file and the code you used?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.