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.

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
1 year ago

Hi RichardLinderma,

Thank you for reaching out to the Microsoft Fabric Forum Community.

 Please check teh updated dax below:

AccountDayTable = 
VAR BaseTable =
    SUMMARIZE (
        'Future_Predicted',
        'Future_Predicted'[AccountCode],
        "MaxDay", MAX('Future_Predicted'[Number_Of_Days_Slider])
    )
VAR _Expanded =
    GENERATE (
        BaseTable,
        ADDCOLUMNS (
            GENERATESERIES (1, [MaxDay], 1),
            "Day", [Value]
        )
    )
RETURN
    SELECTCOLUMNS (
        _Expanded,
        "Account code", [AccountCode],
        "Day", [Day]
    )

 

Thank you.

 

RichardLinderma's avatar
RichardLinderma
Helper I
1 year ago

Thanks. Just need to point out that [account_code] is part of the table 'code' rather than 'Future_Predicted'.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    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.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi RichardLinderma,

    I have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

     

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi RichardLinderma,

    Checking in to see if your issue has been resolved. let us know if you still need any assistance.

     

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi RichardLinderma,

    We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

     

    Thank you.