Add a dynamic vertical line on a combo chart

[Anonymous]

Hi all,

Everything is pretty much in the title : I would like to add a dynamic vertical line on a combo chart.

I've seen that there are solutions to do it depending on the kind of chart you're using, but I can't find a way to do it on the combo chart :

-The Analytics pane can't be used.

-I can't use a column for that (unless there is a trick I don't know yet) as I have measures for both lines and columns.

Is there something I could try ?

Regards,

Martin.

[amitchandak · Accepted solution]

@Anonymous , I am able to add a vertical line using X-axis constant line in the analytic pane. You can do that only for the date and number type of axis. Using FX you can add a measure that can change based on slicer values

[Anonymous]

Thanks a lot !

I was using a hierarchy of date to only show the months, and as a result the Analytics pane didn't work.

It's indeed working with the full date.

Regards,

Martin.