Hey community,
it is my first request for help. Since being very new to Power Bi I was trying to help myself and searched for solutions in the community. But unfortuetly I haven't found any solution yet.
Objective:
I want to show lines for each production year (legend).
Values of the lines are running total of parts [Parts] (y-axis) over month in service [MIS] (x-axis).
I used an addtional measure as values
Running Total = CALCULATE(COUNT(Table[Parts]); FILTER(ALLSELECTED(Table[MIS]); Table[MIS]<=MAX(Table[MIS])))
Problem:
It works without adding production year to legend. Then I have one line combining all production years. If I add it to legend, I get multiple lines which increase and drop 😞
I tried to check "show items with no data" - it doesn't help.
Thank you
Chris
