cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ISUGraber Regular Visitor
Regular Visitor

Link Dots on a trend chart where next available data is a month or two away.

I have a trend chart where I have data in August, October and November.  Is there a way to get the Trend Line to link between all of those months?  It seems to only auto link when the data is in concurrent months.

 

trend.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Link Dots on a trend chart where next available data is a month or two away.

@ISUGraber,

 

You may try measure below.

Measure =
IF ( SUM ( 'Table'[Column] ) = BLANK (), 0, SUM ( 'Table'[Column] ) )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Link Dots on a trend chart where next available data is a month or two away.

@ISUGraber,

 

You may try measure below.

Measure =
IF ( SUM ( 'Table'[Column] ) = BLANK (), 0, SUM ( 'Table'[Column] ) )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.