dynamic whatif parameter

[Anonymous]

Hi,

I have the following table

part of below schema (id<->id)

now i have the following report:

i need to add a filter to this report where i can select a week. however this week cannot be greater than the dim[current week] for this id.

i was thinking of using a whatif parameter but i'm not able to limit it to the dim[current week] 

how would you achieve this?

thanks

[parry2k · Accepted solution]

@Anonymous if you add week slicer from this model, once you slicer the "id", it will also filter week value. Make sure when you use week slicer, the slicer type is dropdown or list.