The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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.
Solved! Go to Solution.
I got the answer. I used another line graph visual developed by Akvelon. Line chart by Akvelon.
I got the answer. I used another line graph visual developed by Akvelon. Line chart by Akvelon.
User | Count |
---|---|
17 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
20 | |
10 | |
5 | |
4 | |
3 |