Clustered Column chart: need a trend line.

[laganlee]

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

[laganlee · Accepted solution]

This is now achieveable in the latest version of Power BI

[Padycosmos]

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

[amitchandak]

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

[laganlee]

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