This one is proving to be quite difficult! I am trying to show monthly weights for a three-year period, and would like a YTD running total line for each of the years on a secondary axis. I know I can do these as separate measures, but then the colors of the column and line will not match up, making it very confusing to look at.
Is there any way to accomplish this??
Below is the DAX I'm using for the Weight YTD line in the image, which is cumulating just the 2022 sales by month. The ideal outcome would be three separate YTD lines that color correspond to the same year in the column values.
Weight YTD =
Thanks for looking.