Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data with years 2018 to 2021.
I want my graph to only show 2020 and 2021 if no years is selected in the filter (years).
If years are selected in the filter then the graph should display the selected years.
What is the expression for this?
Hi,
You can try this.
If( getselectedcount ( Year ) = 0,
Match( Year, Year( Today()), Year( Today ()) - 1),
Year
)
This will always get the current year and last year for you. If you haven't selected anything.
Jordy
Climber
Hi,
You can try this.
If( getselectedcount ( Year ) = 0,
Match( Year, Year( Today()), Year( Today ()) - 1),
Year
)
This will always get the current year and last year for you. If you haven't selected anything.
Jordy
Climber