How to use field parameters in Power BI visuals + how to “dynamically” sort

Power BI field parameters help make your report more dynamic and save a massive amount of space in your report. They also allow for easier data exploration, particularly when used with cross-filtering. I think they're one of the best features added in the last couple of years! This video includes how to create field parameters, use two sets of them in a visual, and set a "default" sort for the chart that updates with different measure selections using bookmarks.

0:00
2:05 Creating field parameters
3:57 Editing field parameters
8:22 Field parameters with small multiples in visuals
8:38 Field parameters & sorting overview
9:58 Creating a second field parameter
12:00 Workaround for sorting in visuals when using field parameters
13:25 Bookmark setup for sorting workaround
18:00 Configuring bookmarks to look like slicer buttons

[CJ-jctn]

Christine - Excellent tutorial on Field Parameters and Bookmarks. I learned SO much in this video. I also love the slower pace of your presentation which prevents me from having to slow down the speed of the video (which usually ends up listening to the presenter as if they had a tad too much to drink 😉).Time to start watching all your other videos on Power BI. Subscribed!

[a_visualcue]

Thank you, Christine! I'm currently building a costs report and I was breaking it down on the main page into three different bar charts. Now I can do that using just one and putting KPIs in space that this solution saves for me :) For sure will use this more in the future.

[Woodborn]

Thanks for the trick about sorting, this fixed my issue. However I'd suggest to create bookmarks into your video description so that we can skip to the location of interest, without having to watch the whole video :)

[jadwiga]

brilliant, this just solved a huge issue I had with my report! thank you!!

[allabout]

Wow. I want to write something how impressed I am with this video, but can not write, nothing logical. I need to digest what I saw. This is absolutely new concept to me. Amazing. Thanks for sharing the knowledge.

[jasonpotwora]

This was a huge help on getting the sorting right! Thank you!

[simeontodorov]

Simple but powerful solution. Helped me greatly.

[henrikguldborg]

Thanks for a great video. I love that the paste in the video and the explanations are not to fast, combine whit super usefull

[bradj]

I thought the background noise was a crackling fire. Turns out it was rain. One can dream lol.

[rrrmqij]

Cristine, thank you for great video and explanation. I’m just struggling with sorting based on measure value when field parameters are used. However if bookmarks should be used to solve the issue, we don’t need field parameters at all (especially for measures). What is your opinion ? (Hope that MS fix this soon)

[TheNetghoster]

Not sure what I did wrong. While my bookmarks work as expected, the buttons won't do anything on the visiual. Is there any setup I missed?

[cdalton]

Christine - one of my measures is a % of total and I'd like that total to reflect the field parameter. Do you know to do that? The usual REMOVEFILTERS function doesn't work.

[keiranhoare]

I couldn't find part 2 of the video, is that available?

Edit: I found it 😊