Forum Discussion

sshan21's avatar
sshan21
New Member
2 years ago
Solved

Sort Order based on a dynamic parameter value

Hi   I have a parameter table with values as below.   The Starting Date for each of these is different, example, YTD starts 1/Jan, Milk Season starts 1/Jun, Shipment Season starts 1/Aug and...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi sshan21 ,

    I did a test for your reference,

    Please check it.

    Please write a measure, use the switch to determine the value selected by the slicer and the corresponding date range, and then put it in the visual filter to set it to 1.

    Measure =

    var _select=SELECTEDVALUE('Table'[Column2])

    return

    SWITCH(

        TRUE(),

        _select="YTD"&&MAX('Table 2'[Date])>=DATE(2024,1,1),1,

        _select="Milk Season"&&MAX('Table 2'[Date])>=DATE(2024,6,1),1,

        _select="Fiscal Season"&&MAX('Table 2'[Date])>=DATE(2024,10,1),1,0)

    Best Regards,

    Sunshine Gu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi sshan21 ,

I did a test for your reference,

Please check it.

Please write a measure, use the switch to determine the value selected by the slicer and the corresponding date range, and then put it in the visual filter to set it to 1.

Measure =

var _select=SELECTEDVALUE('Table'[Column2])

return

SWITCH(

    TRUE(),

    _select="YTD"&&MAX('Table 2'[Date])>=DATE(2024,1,1),1,

    _select="Milk Season"&&MAX('Table 2'[Date])>=DATE(2024,6,1),1,

    _select="Fiscal Season"&&MAX('Table 2'[Date])>=DATE(2024,10,1),1,0)

Best Regards,

Sunshine Gu