Forum Discussion

WoodbeckZach's avatar
WoodbeckZach
Regular Visitor
6 years ago

Setting an Upper Limit on a Slicer Using a Calculated Measure

Hello!

 

I have a week slicer on my dashboard that affects the data shown based off of the weeks the user selects. The dashboard is comparing data from previous years relative to the current year performance. The previous years, obviously, have data for the weeks that this year has not yet recorded (weeks 30-52). I have a calculated measure that is figuring the maximum week in 2020 (which is currently 29) and provides the user with the current week.

 

Is there any way to set an upper limit on the week slicer so the user cannot select a week past the current week (the maximum week thus far in 2020)? Then, when the data refreshes every week, the upper limit would then change to the proceeding week's number.

2 Replies

  • WoodbeckZach  it is easy to do by adding an offset column in the date dimension table? Before we move forward, do you have a date dimension in your model?

    • WoodbeckZach's avatar
      WoodbeckZach
      Regular Visitor

      parry2k  I do have a date dimension! I have not yet created an offset column, though. Could you provide me with some tips to so do, please?