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.

RichardLinderma's avatar
RichardLinderma
Helper I
1 year ago

Another thing to mention is that Number_Of_Days_Slicer is a column rather than a measure.

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.