Paginated Report-Can you sort the parameter dropdown list by a field not in the parameter list?

[ldwf]

I have a PBI Paginated Report with a parameter list.  The data source is a dataset model, so no SQL with an order by statement in this scenario is used.  The list is sorted in alphabetical order, but I need it sorted in another order, i.e, by another field defined in the model.  Is there a way to get the parameter dropdown values to be sorted by this other field that is not to  be displayed in the dropdown?

[Kani]

Is tere a solution yet for the above issues

[zen07]

This might work, if anyone is figuring how to do this - 
In the dataset that you add to the paginated report for getting available values for your parameter, apart from the field that you want in your parameter list, add your order field as well. After doing this, you should be able to add a ORDER BY statement following EVALUATE statement, and use your order field within that.

EVALUATE SUMMARIZECOLUMNS('TABLE'[order field], 'TABLE'[parameter field])
ORDER by 'TABLE'[order field]

[Jon_vB]

If your end user will remain in Power BI app, could you use an "interactive sort" button on the column? (assuming the thing you want to sort by is being displayed).

Add interactive sort to a table or matrix in paginated reports - Microsoft Report Builder & Power BI...

My goal is to change how it is sorted when delivered by subscription to my end user (in Excel).  so, I'm still looking for a solution to this.  perhaps the parameter can be in the Dax.. haven't tried yet.

[mleeson]

Is there a solution yet to this? 

[Sahir_Maharaj]

Hello @ldwf,

Here are two possible approaches:

1. Modify the dataset model: In the dataset model, you can adjust the sorting of the underlying table or query by the desired field. If the parameter dropdown is based on a dataset table, you can set the sorting order of that table by the desired field. Save the changes to the dataset and refresh the report to reflect the new sorting order in the parameter dropdown.

2. Modify the query: If your dataset uses a query to retrieve data, you can modify the query to include an ORDER BY clause that sorts the data by the desired field.

SELECT Field1, Field2
FROM YourTable
ORDER BY AnotherField

Let me know if you might require any further assistance.

[ldwf]

Hi @Sahir_Maharaj .  I did modify the model to sort by the other field.  It does sort the fields but when used in a parameter, by default the parameter still sorts by the original field, not by the other field.  I can instead use a SQL statement in my Paginated Report to get around this problem, but the intent is to use our PBI model (i.e, the published dataset) instead of SQL queries.  So instead of using SQL, I'm looking for a way to sort the parameter values in the dropdown another way