topic YTD on the end of clusterd column chart (one chart) in DAX Commands and Tips

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

Anonymous — Thu, 05 May 2022 15:38:00 GMT

Hello, team.

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

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 🙂

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

tamerj1 — Fri, 06 May 2022 08:42:00 GMT

Hi Anonymous

can you share sample file and the code you used?

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

Anonymous — Wed, 11 May 2022 10:30:33 GMT

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

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

Whitewater100 — Wed, 11 May 2022 13:08:53 GMT

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..

Total Sales = SUM(Data[Sales])

YTD Sales = TOTALYTD([Total Sales], Dates[Date])