Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
johnmelbourne
Helper V
Helper V

Can you hide or re-order parameters?

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?

 

 

Screenshot 2023-12-02 201151.png

2 ACCEPTED SOLUTIONS
danextian
Super User
Super User

Hi @johnmelbourne ,

 

Re-order your parameters in the query editor.

danextian_0-1701516906261.png

danextian_1-1701516957272.png

 

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

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

danextian_0-1701596530216.pngdanextian_1-1701596543714.png

 

 

danextian_2-1701596577966.png

danextian_3-1701596585362.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

6 REPLIES 6
danextian
Super User
Super User

Hi @johnmelbourne ,

 

Re-order your parameters in the query editor.

danextian_0-1701516906261.png

danextian_1-1701516957272.png

 

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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

danextian_0-1701596530216.pngdanextian_1-1701596543714.png

 

 

danextian_2-1701596577966.png

danextian_3-1701596585362.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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

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.

 

ignore.png

 

ignore2.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.