Sort Order based on a dynamic parameter value

[sshan21]

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 Fiscal Season starts 1/Oct.

Depending on which parameter, the user selects below, I want the line graph to change accordingly.

Example, if I select Shipment Season, the graph starts in August. However, when I change the Selection to Fiscal Season, I want it to change to start from October and so on..

Any ideas?

Thanks

[Anonymous · Accepted solution]

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]

Hi @sshan21 ,

Based on your screenshot, my understanding is that the order of the months on the x-axis of the line graph changes dynamically based on what you select in your slicer, is that correct? For example, if you select Fiscal Season, the x-axis order of your line chart would be October, November, December ......... ...July, August, and September, and the chart shows data from October 1, 2021 to the largest date in your data table, and data less than October 1, 2021 is no longer shown in the chart. Could you please confirm if my understanding is correct? As well as could you please provide sample data from another of your tables with date columns and value columns? Thanks!

If I've misunderstood you, please provide detailed sample data and the results you are hoping for. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,

Sunshine Gu

[sshan21]

Hi Sunshine

That is correct. 

If I select Fiscal Season, the chart should show data from october to september (next year).

If I select Shipment Season, the chart should show from August to July and so on.

Thanks