Forum Discussion

RichardLinderma's avatar
RichardLinderma
Helper I
1 year ago
Solved

Slider problems

I have the following calculated DAX table, used on a slider: Future Travel Slider = VAR MaxValue = MAX('Future_Predicted'[Number_Of_Days_Slider]) RETURN ADDCOLUMNS( GENERATESERIES(0, MaxValue, 1...
Need Help
Show and Tell
Tips and Tricks
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi RichardLinderma,

    Please check the below pbix file by using sample data by switching to dropdown in the visual.

     

    If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi RichardLinderma 

Power BI slicers don’t dynamically adjust their range based on another slicer’s selection when the values come from a calculated table like your Future Travel Slider. Calculated tables are static at refresh time and don't respond to slicer selections.

Workaround:

  • Move the slider logic into a measure or a calculated column that reflects the selected account_code, or

  • Use a What-If parameter instead of a calculated table, but be aware the range won’t dynamically shrink/grow.

  • If you need the slider to adjust dynamically, you’ll need to use a field from your data model that’s directly affected by filters (not a calculated table). Consider filtering visuals with a normal slicer, not a dynamically-generated one.

 

  • RichardLinderma's avatar
    RichardLinderma
    Helper I
    1 year ago

    Hi rohit1991,

     

    Thank you for your message. Would you be able to give me the DAX functions for this?