Fields Parameter Tip 2 - Fix Category Sort Order

🔽More Information below🔽
Another tip when working with the new Field Parameter
- How to set the sort order of a chosen category
Dummy Data sets can be found here
accessanalytic...
Solution file here
aasolutions.sh...
Previous video on this topic
• Fields Parameter - how...
Connect with me
wyn.bio.link/

[@rob123456hawke]

thanks for this great tip! It works, though it makes absolutely no sense to me why the system behaves that way. I have a numeric Year column where I now need to add a second Year column and specify that one as a sort column for the first one just as a workaround. I wish Microsoft would simply fix this behavior and keep the sorting by Axis instead of by Measure even when the field changes.

[@AccessAnalytic]

🤷🏻‍♂️

[@PeterKontogeorgis]

Nice one - this was driving me crazy about 3 months ago. Can't believe MS are yet to fix it.

[@AccessAnalytic]

You’re welcome

[@chaitubhogireddy]

This really helps. but i want to sort matrix visual based on a sort measure. could you please help on how to do that

[@AccessAnalytic]

Not sure what you mean by sort Measure sorry.

[@Bhavik_Khatri]

Nice little tip

[@AccessAnalytic]

Thanks Bhavik

[@VictorHugo-bd3bf]

Thank you so much; that solved my issue.

[@AccessAnalytic]

Thanks for letting me know it helped

[@oldrose8377]

Thank you so much for the useful tip. If you would not mind, I have a little question that if we fix the category and use the field parameter to change measures instead, then how should we fix the sorting to always be ascending for each measure? As I tried, switching measures will have sorting order back to descending every time. Thanks in advanced for the answer : )

[@AccessAnalytic]

Good question, I don't know the answer to that. It doesn't appear to be possible

[@bazej1387]

In this case instead of field parameter for measures try to use SWITCH function with SELECTEDVALUE as a condition.

[@katieo6802]

It appears possible by setting a bookmark and using bookmark navigator buttons instead of the default parameter slicer! ruclips.net/video/Nt3QgZrJXfY/видео.html

[@user-st7xe8zw4d]

Hello, it works when I use text field parameters. In my case I use date, start of week, start of month, start of year als field parameters (all date types) but those sort order columns are the same as the column itself so then it doesn't work. I need it to always sort the table descending when the user select month, week, year, day...

[@AccessAnalytic]

I think you should still be able to use a separate numerical sort order number column ( add via Power Query ) for each field - even if a date.

[@sararodriguezperez1111]

Thank you!!

[@AccessAnalytic]

You're welcome!

[@PaulBailey3]

what about a field parameter that has a date column and another that is a count? How could I achieve this?

[@AccessAnalytic]

Not sure what you mean by a column with a count sorry

[@Simon-vc1wk]

Is there a way to apply conditional formatting to fields parameters. Not found a good way yet

[@AccessAnalytic]

Check out minute 16:30 ruclips.net/video/ksmNfa_K8GQ/видео.html

[@reet332]

cell elements in format option of table

[@arungarlapati3376]

can I change localization on field parameters , column name & fields name

[@AccessAnalytic]

I’m not sure Arun, does this help blog.gbrueckl.at/2022/06/using-power-bi-field-parameters-to-translate-data-and-values/ ?

[@fauzanmauludy7973]

How if we want to sort Hours by another column?

[@AccessAnalytic]

Can you give an example please

[@Ekercim1]

I have y/q/m and I tried to sort from year but it doesn't do anything

[@AccessAnalytic]

If year is text you will need a sort it by a numerical version of the column

[@anetakn6601]

What if my field parameter is created of measures?

[@AccessAnalytic]

Hi, You can edit the DAX formula for the Parameter that is generated. The Sort order is the number at the end of each line of the DAX code