Adding YTD in a weekly Stack Graph

[ranz_vincent]

Hello, so I am having trouble on how to add a YTD columns to my visual and I was hoping find a way to add a YTD value that counts the distinct value of all the dates beside the weekly values. Also if I can use the suggested solution in making YTD values if I wanted to make another visual for Daily, Monthly or Yearly.

YTD sample data - Google Drive 

[danextian · Accepted solution]

Hi @ranz_vincent 

You'll need to use a disconnected table that includes the week numbers, as well as an extra row for YTD. Then, create a measure to return the value based on either the week number or whether the row is for YTD.

Please see the attached pbix.

[ranz_vincent]

I tried using this and used it on my report but the YTD column is not showing and I noticed that the sample data used in the file you sent was shown as January1, February1,March1...  the sample data should be from January1-10 could this be a factor on why the YTD column isn't showing?

[ranz_vincent]

I've figured out the the reason YTD column was not showing. I just needed to add a year filter and select the year. Thanks a lot