Add a YTD bar to a visual

[Astolfo]

Hi all,

i was wondering if it's possible to add a YTD bar to a visual that shows the weekly revenue of the last week.

i have this graph that shows revenue of the week vs revenue of previous week filtered by week and year, my question is if i could add a third bar that shows the revenue of the year until that week selected. Thanks

Regards

[pratyashasamal]

Hi @Astolfo ,
Yes you can add YTD bar to this visual .
You can use this calculation for YTD 

For example :- YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"))
It would look something like this 

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C