Reference line only added with the measures and not dimensions.
1 of 1 people found this helpful
Maybe Edit Axis > Tick Marks is all you need.
See more in The specified item was not found.
Here is a nifty, and little counter intuitive solution for you!
What I've done here is create a calculated field called 'March Reference Line' with the formula
IF DATEPART('month',[Order Date])=3 THEN 0 END
(I've set month to 3 as per your example, but this could be any month)
You then set the reference line from the Y Axis with the following settings
and there you have it.
Hope this helps, if not, or of you want a bit more detail on how it works, please post back
Still this is a useful read. thank you
Wow - well done! At first I didn't think it would work because I needed my scale to remain automatic. But when I changed the value to [Qty] vs. 0, it worked perfectly!
Excellent News...It's a bit of a strange one, and bit counter intuitive.
Here are a couple of other uses of the same trick, to create (essentially) Column Banding!
I just had ANOTHER use case for this today. Works so well, and looks so much better than my other feeble attempts!