Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

Submitted by Anonymous on ‎06-29-2023 12:04 PM

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.

ShellerA_0-1688065300754.png

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

ShellerA_1-1688065362078.png

 

Status: Delivered
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎06-29-2023 06:43 PM

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
Not applicable
‎06-30-2023 07:29 AM

@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
Advocate I
Advocate I
‎06-30-2023 09:46 AM

@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
Not applicable
‎01-18-2024 08:03 AM

@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
New Member
‎09-13-2024 04:42 AM

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...

Idea Statuses