You can probably use a table calculation to get the max value, add this to the level of detail for the second sheet, then set a reference line using this. See the attached - I have not taken the next step of formating the ref line to be not visible.
axis fix.twbx.zip 1.5 MB
Nice Avatar by the way ;-)
I tried something similar to this. The problem is that the two charts have different date ranges. Chart 1 is THIS MONTH and Chart 2 is an average of the 5 months prior to this month. A table calc works when the date filter is off/the same but not when they are different.
Any ideas about this?
Do you have a filter on the second that's causing the reduced range?? If so, then there is one possibility
I've got a date filter on both charts.
Chart 1: Filtered to show the last 6 months of data (not including the most recent month)
IF[Date]< DATEADD('month',-1,DATETRUNC("month",Today() )) AND
[Date] >= DATEADD("month",-7,DATETRUNC("month",Today() )) THEN
Chart 2: Filtered to show the most recent months data
IF[Date]< DATETRUNC("month",Today() ) AND
[Date] >= DATEADD("month",-1,DATETRUNC("month",Today() )) THEN
What's the possibility?