Add a constant line on a Line and Stacked bar charts

[yanx1990]

Hello,

I have a visual Line and stacked column charts where I'd like to add a constant line. I noticed that it's not possible with this kind of visual so I tried using a measure "Measure = 40". When I had the measure to my visual, it's indeed showing the constant line 1.5 but it shown all the values without taking in count my axis filter (visual filter based on the date) : 

Here's my original graph with filters : 

And here's when I add the measure = 40

How can I do to have the measure also filtered by the Created time ?

Thanks a lot for your help.

Kind regards,

Yannick

[mussaenda · Accepted solution]

Try filtering your other values in the visual (Filter Pane) like count of request ID is <> to 0.

[yanx1990]

D*mn, it was so simple... I didn't even realize I was not on the same Table (Created Time and Request ID) !

Well, thanks a lot for your fast and perfect reply 

Have a nice day !