Forum Discussion

Dave82's avatar
Dave82
Frequent Visitor
4 years ago
Solved

Show categorical dates with continuous lines?

I have a table with a date hierarchy for the x-axis on the line graph visual.  We are showing monthly averages from each of the plants and want them broken out by year/month categorically.  The issue...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Dave82,

    Current you can't use options to keep these data points linked except you remove the legend field. 

    For your requirement, perhaps you can write measures to look up the previous results if the current data points that do not exist values and use this measure on the value field. (the previous date point will plot a straight line to the next date point which has values)
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Dave82,

Current you can't use options to keep these data points linked except you remove the legend field. 

For your requirement, perhaps you can write measures to look up the previous results if the current data points that do not exist values and use this measure on the value field. (the previous date point will plot a straight line to the next date point which has values)
Regards,

Xiaoxin Sheng