X-axis parameters for my chart do not save my sort-by preferences.

[Anonymous]

Hello,

I used a parameter to create different options to slice the date by in the x-axis in my line chart.  My options were to view the chart by week, month, and quarter.  After creating the slicer to click between those date options, I notice my sort-by peferences are resetted after I click to a different date option.  I was wondering if there is a way to fix this or if there was a ticket  out for this.  

This is when I initally creat a sort-by.

This is what it looks like after I click through a different option and then click back on "Fiscal Week"

[Anonymous]

Hi @Anonymous 

You can solve the sorting problem caused by switching parametres by creating a sorting metric.

Solved: Field Parameters sort order - Microsoft Fabric Community

Solved: Sorting on Parameter fields measures - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao

[Anonymous]

@Anonymous I appreciate the quick response.  I do not want to sort by my values, but by my x-axis.  These solutions did not work as the parameters I am using do not use a measure.  These dax expressions require a measure onhand to work properly.  I am just using date fields as my parameters and I am not sure how to modify the dax to make these work.  Are there any solutions for anything not related to using a measure since it is not appropriate for my date columns?  I want mine sorted by fiscal week.  Is there any way to apply to columns rather than measures?  

[birknerj]

@Anonymous you could try this solution presented by Access Analytic. I believe this would impact the default sort order for the selected columns across the report though. Just something to keep in mind.

https://www.youtube.com/watch?v=vo-8p7_3yZk

[Anonymous]

@Anonymous In case you are still struggling with this, I was able to find a quick workaround that solved the issue for me.

I simply added my date field (from my Time Dimension) as a tooltip, and sorted my chart by this field.

I believe this only works if your field parameter only includes time fields - as it seems to be the case in your example.

[CL2000]

Hi OP,

If you’re still looking for a way to prioritize which columns to sort by, I’m quite confident that this video explains a solution to your problem.

https://www.youtube.com/watch?v=GfBrB6czByw&ab_channel=AmitChandakLearnMicrosoftFabric%2CPowerBI%2CS...