Solved: Constant line in "Line & clustered column chart"

Anonymous · ‎12-27-2018

Hi All,

I have a requirement of constant line in "Line & Clustered column chart" is there any way to implement the same.

AnkitBI · ‎12-28-2018

I believe you can simply create one Measure. You can then pass this measure as Line Value. You do need something in the Shared Axis, if you don't want to show anything on Shared Axis you can hide from settings.

Measure 1 = 0.5

Regards
AJ
Do Like Post if response seems good and Worth liking.
Do Mark as Solution if response resolved your Issue.

View solution in original post

Anonymous · ‎12-28-2018

The constant line should be 0.5

v-piga-msft · ‎12-30-2018

Hi @Anonymous,

It seems that Line & clustered column chart is not supported for a constant line from the Analytics pane, the suggestion of AnkitBI should be helpful.

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AnkitBI · ‎12-28-2018

I believe you can simply create one Measure. You can then pass this measure as Line Value. You do need something in the Shared Axis, if you don't want to show anything on Shared Axis you can hide from settings.