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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
parry2k
Super User
Super User

Learn how to create/manage field parameters dynamically-Take your Power BI reports to the next level

💡 What about making field parameters dynamic? 💡

 

Field parameters are one of the coolest features in #powerbi that allows users to dynamically changes columns on the x-axis/rows and/or measures, It allows you to dynamically change:

 

👉 what do you want to visualize

👉 and how you want to visualize it

 

👏 Also, one of the use cases of field parameters is to have a dynamic hierarchy. A hierarchy gets created in the visual based on user selection in a slicer. It is one of the very powerful features of field parameters (in my opinion).

 

Now, what about making field parameters dynamic? Instead of opening the #powerbi data model, and updating field parameters based on the continuously changing business requirements, can this be dynamic?

 

📢 This is exactly what this video will showcase. We will deep dive into how we can update/change field parameters dynamically without opening the #powerbi model file, and can easily scale the reporting requirement using field parameters.

 

👨‍🏫 We will also look into how we can update all the metadata related to field parameters, like changing the display name, the grouping of field parameters, and changing the sort order.

 

💡 At end of the day, you will some interesting techniques from this video that will help to take your reports to the next level.

 

https://youtu.be/xjBVKLn5fzs

 

Dynamic Field Parameters (Time 0_00_03;00).png



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

Hi @parry2k ,

Thanks for sharing.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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