Chart not responding to selection

[Di]

Hi, for a line chart, I have included the following in the measures to limit the chart areas to years 2015 to 2019:

Avg({<[Year]={">=2015<2020"}>}Vacancy)

However, when selecting specific years (e.g. 2017-2019) on storyboard, the chart does not seem to respond to the selection. Any help on this?

[PrashantSangle]

Hi,

It is because you hard coded that value. you can create your set analysis more dynamic

try below

Avg({<[Year]={">=$(=min(Year))<$(=max(Year))"}>}Vacancy)

Regards,

Prashant Sangle

[Di]

Hi, thanks for the prompt response! But this displays all the values though (year 2002 to 2020). My original expression allows me to display only year 2015 to 2019 on the chart, but only issue is that it's not responding to selections in storyboard. Any alternatives?

[Vegar · Accepted solution]

Try this

Avg({<[Year] *={">=2015<2020"}>}Vacancy)

[Di]

That's great, it's working perfectly now! Thanks!!