Forum Discussion

RichardLinderma's avatar
RichardLinderma
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
1 year ago

This is very interesting. Would you be able to adjust my code based on the AccountDayTable you provided, please?

RichardLinderma's avatar
RichardLinderma
Icon for Helper I rankHelper 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
    Icon for Community Support rankCommunity 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
      Icon for Helper I rankHelper 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
        Icon for Community Support rankCommunity 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.