Forum Discussion
Remove gaps in stacked area chart
Hi,
When I try to plot a stacked area chart where some of the series doesn't start with any data, it leaves gaps in the graph:
Is it possible to make the lines connect to null values to fill those gaps in?
Thank you for the help.
Hi Anonymous ,
1 create a new table via values(table[x-axis])
2 set the newtable[x-axis] as the X-axis of the stacked area chart
3 create a measure like the following:
Measure = VAR _s = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = MAX ( 'New Table'[Date] ) ) RETURN IF ( ISBLANK ( _s ), 0, _s )Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-chenwuz-msft
Community Support
Hi Anonymous ,
1 create a new table via values(table[x-axis])
2 set the newtable[x-axis] as the X-axis of the stacked area chart
3 create a measure like the following:
Measure = VAR _s = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = MAX ( 'New Table'[Date] ) ) RETURN IF ( ISBLANK ( _s ), 0, _s )Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.