Can you hide or re-order parameters?

[johnmelbourne]

Can you hide or re-order parameters? such that when you select edit parameters, the transform parameters that are created when you have a source of a folder don't appear, or appear below others?

[danextian · Accepted solution]

Hi @johnmelbourne ,

Re-order your parameters in the query editor.

[danextian · Accepted solution]

Hi @johnmelbourne ,

Re-order your parameters in the query editor.

[johnmelbourne]

Sorry, but doesn't work.  It appears to show parameters in the order created, not the order sorted in the GUI.

[danextian · Accepted solution]

Just tested again. Re-ordering the parameters should work. Please don't forget to apply the querty changes after re-ordering

[johnmelbourne]

Do you know how to reference the value in a measure?
Noting it is not a table parameter. 

[johnmelbourne]

It's ok, I found how to reference the parameter here: https://www.fourmoo.com/2016/12/07/power-bi-using-parameters-in-calculated-measures-making-calculate...

[johnmelbourne]

Thanks for the follow up reply. 

I saw that it indeed does work for you, and in Power BI not just Excel PQ.
So I played around, and for data source of type folder, the parameter query needs to be moved from the default folders created into another folder to change the sort order. 

I moved all the parameters out of default folders for Folder Source queries into a new folder, and then was able to arrange as needed.  A small quirk related to data source of folder. 

Thanks very much for your support to find a solution and screen shots to show it could be done.  I then had the confidence to keep playing to find the work around / required format. 

All in the one folder helped.  Once I did that, I could also create other folders and it continued to work. 

Many thanks again.