I have this bar chart below in which I need the latest month to be selected, (this would have an action filter which would affect other charts):
What I did is I create a new column which renames the latest month into 'Latest' and have 'Latest' selected.
I created this dashboard last month with 'Latest' selected (at that time it's March).
However when I checked it out today, (April 2nd), the selection is 'Mar' and not 'Latest'.
Anything I did wrong? Is there another way to do this?
Could you please refresh the data source once, assume something in the cache is altering the Calculated Field.
If refresh doesnt work will recommend you to share your .twbx file.