Forum Discussion

tpchauke's avatar
tpchauke
Frequent Visitor
7 years ago
Solved

Running total line graph breaks when there is missing data.

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

  • I got the answer. I used another line graph visual developed by Akvelon. Line chart by Akvelon.

2 Replies

  • tpchauke's avatar
    tpchauke
    Frequent Visitor

    I got the answer. I used another line graph visual developed by Akvelon. Line chart by Akvelon.

    • michael-rogers's avatar
      michael-rogers
      New Member

      Hi,

       

      Please can you show again the solution?

      It is not visible anymore in the reply.

       

      Michael