I have a graph that I created, the formula is cumulative but the line breaks when there is no data, how can I connect the data i tried to use continuous type but power bi does not allow me to change to it since the legend is not numeric.
This is the formula I used for the running total.
RunningTotal = CALCULATE( SUM ( 'Base'[Amount]), Filter( ALL ( 'pbiDimDate' ), 'pbiDimDate'[Date] <= MAX( 'pbiDimDate'[Date] ) ))
I would be glad if you will be able to assist me.
the line breaks and i want it to be continuous since the formula is cumulative