Forum Discussion

laganlee's avatar
laganlee
Icon for Helper II rankHelper II
3 years ago
Solved

Clustered Column chart: need a trend line.

Hi

This seems like a really simple thing to ask for!

I need a trend line for a clustered column chart.

Currently it is using a date hierarchy for x axis and % measure for the y axis.

I have tried various obvious things, such as using continuous option for x axis 

and used a separate date table and use a numerical month number for the x axis.

Many thanks for looking.

Clustered Column

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    laganlee , seem like you are using date hierarchy, use date instead and then use continuous axis

     

     

     

    • laganlee's avatar
      laganlee
      Icon for Helper II rankHelper II
      3 years ago

      Hi Amitchandak

      Thank you very much for your answer, that is very much appreciated!

      I'm getting very close now 🙂 

      I just need to bars to be just one per month? (as in the original format)

      Is that possible?

      Kind regards

  • Padycosmos's avatar
    Padycosmos
    Icon for Solution Sage rankSolution Sage
    3 years ago

    The work around could be adding Month Name to the legend.

     

  • laganlee's avatar
    laganlee
    Icon for Helper II rankHelper II
    3 years ago

    This is now achieveable in the latest version of Power BI