Show last month in chart if no month is selected in another chart.

[oscarmqz]

Hi, I have two charts. One is monthly and the other shows daily bars. I edited the interactions in the monthly one, so when a month is selected, the daily charts is filtered to that month only, instead of highlight. So far so good.... the problem I've not been able to fix is that if no month is selected in 1st chart, I'd like to show latest month by default on the daily chart. Any idea how to achieve this? Thanks in advance!

[vega]

Did you try using the ISFILTERED or ISCROSSEDFILTERED function? You can do something along the lines of:

Measure :=

IF(
ISFILTERED('Date Table'[Months]),
[Regular Measure],
[Measure that returns results for only the latest month]
)

If you are having difficulty coming up with the measure for the last month only, it should be something along the lines of:

[Measure that returns results for only the latest month] :=

CALCULATE(
[Regular Measure],
'Date Table'[Month] = MAX('Date Table'[Month])
)