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?
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.
Marita // firstname.lastname@example.org
It perfectly works!
Thank you so much!