Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago
Solved

Trendline needed

I have a simple linechart with MonthName on the x-axis (this is derived from my own custom built calendar going from Apr to Mar as per Financial Year) and a DISTINCTCOUNT Measure of IDs for the Y axi...
Need Help
Show and Tell
  • nleuck_101's avatar
    nleuck_101
    3 years ago

    ArchStanton 

    I would think they would be the same line.

     

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago

Thanks, I've finally got it to work ğŸ˜Š

I've notice the trendline is far steeper with your Variable (see solid line in top line graph) compared to when I use the inbuilt Trendline using the Continuous x Axis date range. This inbuilt range has every other month missing which is why I'm desperate for an alternative option.

I guess I need to decide which one to use. My only other option is to Snip an image of the the x axis with complete months and paste them over in Powerpoint when this get presented, incredible we still have to do this in 2023!

Thanks for all of your help!

nleuck_101's avatar
nleuck_101
Continued Contributor
3 years ago

ArchStanton 

I would think they would be the same line.

 

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    3 years ago

    Thanks for helping me with this, much appreciated!

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    3 years ago

    as per screenshot, one is far steeper than the other. Its fine though, I can use either