Fixed horizontal line without any data in Line Chart

Hi guys,
I am using a Line Chart and a horizontal line could be inserted by using “Define calculated member formula” with a specific value.
But when I click on the horizontal line, it has some data in “Drill through issues”.

How can I create a horizontal line without any data/info?

Hi @Kyung_Park,

Thanks for your question.

You can use annotations to limit or change some report interaction features: Calculated measures and members

In your case, you need to disable all drill actions for the calculated member by adding -- annotations.disable_drill=true as shown in the example below, and updating your formula.

The report will no longer offer Drill options for this calculated measure in your report:

I hope this answers your question.

Kind regards,
Marita //

Hi @Marita_Norvele
It perfectly works!
Thank you so much!

1 Like