There might be some different options depending on how you are creating the two lines.
Are you using:
It may possible to use some differential padding in the label dialogue.
Could you also post the guts of your LOD calculated field?
I think there should be ways to just have the last date shown in a separate chart.
Thanks for the reply! I've included a quick mock up of what I'm working with.
I was wrong, I don't have LOD calculations. The value of the each line is calculate by previous_value([investment]) * (1 + avg([qtd returns])) where investment is the parameter that a user can input. And then the industry average is the same except the instead of [qtd returns] it's [avg qtd returns].
I'm then using dual axis to show the stock compared to the industry average. The dimension is the stock chosen in the filter. And the value of the investment and the value of the industry average are the two measures.
Temp.twbx 28.0 KB
Find my approach below,
I've created one dynamic reference line on your date axis using below calculation which will add some padding.
Then add ref. line on your axis and set the label alignment, marks to label and scope as per below screenshot and check.
Finally it should look like this
workbook attached for your reference. Let us know if this help.
Temp_v10.2.twbx 28.6 KB
I think you can get the last stock Value using:
IF LAST()=0 THEN [Value] END
while placing month on the detail shelf
and setting the compute using to Month.
Similarly with Avg Value.
But, I'm not seeing a way to flip their
order if the Stock Value becomes
lower than the Avg Value.
Please see workbook v18.1 attached in the Forum Thread:
289319stock.twbx 39.0 KB