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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Jain1707
New Member

Parameters

Hi, i created 3 dynamic filters to open a certain file using parameters, now how to bring these parameters in front so that i or anyperson can change it from the list of values and PBI can open other file as needed.

2 REPLIES 2
Jain1707
New Member

Hi Sahir

Thanks for your response that really helps.

On this continuing topic, when i try to create a slicer how to link the parameters , as i dont see them in tables other than transform data.

 

Thanks

Animesh

Sahir_Maharaj
Super User
Super User

Hello @Jain1707,

 

For each parameter, you can define a list of values that users can select from. This can be done by going to the "Manage Parameters" option and setting the "Suggested Values" to either "List of values" or "Query".  If you choose "List of values", you manually enter the values. If you choose "Query", the list will be populated based on the results of a query.

 

In Power BI Desktop, you /your users can change parameter values from the "Transform Data". Here, you /your users can select "Manage Parameters" and change the values as needed. For Power BI Service, maybe consider creating a slicer or filter that interacts with these parameters.

 

Hope this helps - Should you require any further assistance, please do not hesitate to reach out to me.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.