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