How to use field parameters in Power BI visuals + how to “dynamically” sort
ฝัง
- เผยแพร่เมื่อ 15 ก.ย. 2024
- 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
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.
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!
Thanks, your comment made my day today!
brilliant, this just solved a huge issue I had with my report! thank you!!
Great to hear!
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.
Aw that means a lot to me, thanks so much for taking the time to share your feedback. :)
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 :)
Thanks! I have been meaning to, I’ll start with this one :)
This was a huge help on getting the sorting right! Thank you!
Awesome!
Simple but powerful solution. Helped me greatly.
This is genius, thank you so much!!
Thanks for a great video. I love that the paste in the video and the explanations are not to fast, combine whit super usefull
Hello
It all works great except that my bookmark navigator won't leave edit mode. I am therefore not allowed to switch between the 2 bookmarks. Is this a known problem and is there an obvious solution.
Cool video. Thanks for sharing.
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.
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?
Which buttons are you using? The bookmark navigator buttons will automatically use your bookmarks, so they should have the same behavior as your bookmarks. If you're referring to the field parameters, those need to be added into the visual in one of the wells in order to do anything also. :)
@@bi-ome I am using the bookmark Naigator buttons. I found out the reason. It seems that I have to hold the ctrl button to make click on the bookmark navigator button work. It there a setup I can switch to click without holding the ctrl button? Thank you for your response.
@@TheNetghoster Oh, yes, this is just how bookmarks work in the desktop version. Once you publish it, you won't have to hold control in the web.
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)
Thanks! You do still need to use them in order to change which measure is being used in the charts! Bookmarks only let you change sort, filter, and visual visibility. :)
I am hope we get more updates to field parameters in the future also, they are very fun with tons of possibilities!
that is absolutely brilliant! thanks
I thought the background noise was a crackling fire. Turns out it was rain. One can dream lol.
Ha, I wish I had a fireplace. I got a pretend one. It’s not a bad idea to put a speaker on it and play fire noises. 🤣
😂 I play a virtual fireplace on a small desktop monitor all day, while I work… while living in FL 😅
Well, if you’re going to have a fire in Florida that does sound like the best way to do it! :)
@@bi-ome 🧠 ✅ 🤣
Thanks for the insight. How did you get those stacked bar charts?
It's a normal standard bar chart, but uses the "small multiples" option - you can drag a dimension field or parameter into small multiples, and it makes ... smalll... multiple bar charts for the thing. :)
@@bi-ome thanks a bunch
I couldn't find part 2 of the video, is that available?
Edit: I found it 😊