Skip to main content
Solved

Configuring allowed items on page selector that is a variable

  • Oct 30, 2026 1:32 PM UTC
  • 2 replies
  • 68 views

Bas
Master Author
Forum|alt.badge.img+9
  • Master Author

Hello,

I have a couple of boards that have ‘Month’ as a page selector. By default these are set on the current Month (driven by a variable). Based on the same variable I have some calculated items in tables (for example YTD calculations). 

In the page selector I can then select a particular month to switch back and forth between months and the YTD calculation changes accordingly. Works fine. 

But I would like to limit the allowed items in the page selector. At the moment the users have to scroll through a list of months from 2021 to 2030 to select the month. I would like to limit those allowed items to only the current year. The problem is that the month selector (hidden) defaults to the variable, but for the variable (visible) I cannot manipulate the allowed items (greyed out).

Any help is much appreciated. I have asked this before in the community, but unfortunately I didn't find the time to really dive into the solution just yet.

I have filtered all the tables on the specific board by a variable ‘current year’. Unfortunately that did not limit the dropdown in the page selector.

 

Thanks, Bas

Best answer by Weining

Hi Bas,

I don’t know of a quick, simple way to do this, but there are two options:

  1. Switch to Year + Month of Year. Rebuild your metrics on Year and Month of Year instead of Month. It makes limiting the selector to the current year easy, but I guess it’s a big change to your whole model.
  2. Use a subset. Create a subset of Month with only the current year’s months, and point your metrics to it.

Hope this helps!

View original

2 replies

Forum|alt.badge.img
  • Apprentice Helper
  • Answer
  • Nov 9, 2026 7:21 AM UTC

Hi Bas,

I don’t know of a quick, simple way to do this, but there are two options:

  1. Switch to Year + Month of Year. Rebuild your metrics on Year and Month of Year instead of Month. It makes limiting the selector to the current year easy, but I guess it’s a big change to your whole model.
  2. Use a subset. Create a subset of Month with only the current year’s months, and point your metrics to it.

Hope this helps!


Forum|alt.badge.img+2

Building on Weining’s subset option: you can make the subset maintain itself. Add a boolean property on Month that is true when the month’s year equals your current year variable, and drive the subset from that property. The selector then shows 12 months and rolls forward when the variable changes, with no rebuild of the model on Year and Month of Year.