Slider problems

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.

  Hi RichardLinderma, I tried to iterate on your problems in Power BI and come up with a solution.

Measure for Cards 

And as you can see, when i select maximum days is showing 70 and there is no reflection on the Future Travel Slider 

 

Download the Sample Solution File: https://getshared.com/BG3FoAHd 

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!

Hi RichardLinderma 

Calculated tables and columns are not aware of slicer selections, so even though you can reference a measure inside them, its value won't change based on slicer input. In your case, the value of the MaxValue variable will always return the actual max of 'Future_Predicted'[Number_Of_Days_Slider], regardless of what is selected in the slicer. The calculated table must already contain all possible rows for every potential selection. For example, if account code 001 has a max value of 70, the table should include a column identifying that account and another column with rows from 1 to 70.

Sample calc table

AccountDayTable = 
VAR BaseTable =
    DATATABLE (
        "AccountCode", STRING,
        "MaxDay", INTEGER,
        {
            { "001", 70 },
            { "002", 50 }
        }
    )
VAR _Expanded =
    GENERATE (
        BaseTable,
        ADDCOLUMNS ( GENERATESERIES ( 1, [MaxDay], 1 ), "Day", [Value] )
    )
RETURN
    SELECTCOLUMNS ( _Expanded, "Account code", [AccountCode], "Day", [Day] )