Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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?
Solved! Go to Solution.
Hi @johnmelbourne ,
Re-order your parameters in the query editor.
Proud to be a Super User!
Just tested again. Re-ordering the parameters should work. Please don't forget to apply the querty changes after re-ordering
Proud to be a Super User!
Hi @johnmelbourne ,
Re-order your parameters in the query editor.
Proud to be a Super User!
Sorry, but doesn't work. It appears to show parameters in the order created, not the order sorted in the GUI.
Just tested again. Re-ordering the parameters should work. Please don't forget to apply the querty changes after re-ordering
Proud to be a Super User!
Do you know how to reference the value in a measure?
Noting it is not a table parameter.
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...
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.
User | Count |
---|---|
93 | |
90 | |
90 | |
81 | |
49 |
User | Count |
---|---|
156 | |
145 | |
104 | |
72 | |
55 |