Forum Discussion
Adding YTD in a weekly Stack Graph
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
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.
3 Replies
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.
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?
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
