I'm not sure if this will work for your true setup, but maybe it can give ideas.
I first unioned the dataset to itself, which generated a new field called [Table Name].
Then I created a field that will be used to link the quarter in the graph to the quarter in the table:
DATE(IF [Table Name]="Sheet 1.csv" THEN DATETRUNC('quarter',[Date])
This takes advantage of the two copies of the table to generate one quarter and the quarter before.
So the dashboard action is from Quarter(Date) on the Graph to QuarterLinkDate on the table
which will pull up two months, one from one copy of the table, and then the previous month
from the other copy of the table.
The most recent quarters becomes:
Because it uses QuarterLink, it will pull up two most recent months.
The last part is to show the two most recent months if nothing is selected.
In that case, the Max Quarterlink is not equal to the Min Quarterlink, so:
AND MAX([Most Recent])
// With a Compute Using of "Table Down"
Please see workbook v10.4 attached in the Forum Thread:
288637quart.twbx 81.3 KB
This is great. Thank you! +