Forum Discussion
reset YTD line
I have a situation where I am using a column/line combo chart, showing monthly values in the columns and YTD values on the lines. The user would like to see multiple years side-by-side (instead of stacked since we're looking at multiple values at once), but the YTD line doesn't "reset" when going from Dec 2018 to Jan 2019, and the diagonal line looks awkward.
Here is the general idea of what I want to see (this is using "Year" as the column series, so only one value is allowed - plus the legend is very hard to understand):
But here's what it ends up looking like (with multiple values in the column, but no series)
The connection between the high point in Dec 2018 and the low point in Jan 2019 is what I'm trying to remove.
Here is the data with which I made the chart, which resemble my real data in structure. The date field is linked to a Date table.
| Date | Amount | Amt |
| 1/1/2018 | 50 | 5 |
| 2/1/2018 | 50 | 5 |
| 3/1/2018 | 50 | 5 |
| 4/1/2018 | 50 | 5 |
| 5/1/2018 | 50 | 5 |
| 6/1/2018 | 50 | 5 |
| 7/1/2018 | 50 | 5 |
| 8/1/2018 | 50 | 5 |
| 9/1/2018 | 50 | 5 |
| 10/1/2018 | 50 | 5 |
| 11/1/2018 | 50 | 5 |
| 12/1/2018 | 50 | 5 |
| 1/1/2019 | 100 | 10 |
| 2/1/2019 | 100 | 10 |
| 3/1/2019 | 100 | 10 |
| 4/1/2019 | 100 | 10 |
| 5/1/2019 | 100 | 10 |
| 6/1/2019 | 100 | 10 |
Is there anything in DAX or in the settings that I am missing that can do this?
Thanks in advance,
David
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi dedelman_clng,
Based on my test, it looks like the best choice is to add "Year" to chart legend to break the line. Without legend, all date points across multiple years are recognized as continuous dates.
Regards,
Yuliana Gu