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.
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.
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 :)
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!
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.
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.
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. :)
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!
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.
The field parameters are one of the best features of Power BI, totally worth getting into the coding stuff! You don't even have to write the code yourself, it writes it for you. 😄
Great content as always- You should be able to sort your parameters without creating bookmarks by creating a selected value type measure. Create this measure and put it in your tool tip- then you should be able to use the 'sort by' by clicking the ellipsis and can select measure you put in your tool tip. A measure like this for example: Prm: Sort Selected Measure = SWITCH( MAX( Prm_Measure_Switch[Prm_Measure_Switch] ), "Sales Amount", [Sales Amount], "Sales Quantity", [Sales Quantity] ) That should stick when clicking between parameters. Credit to Bas: ua-cam.com/video/rx_vq1jgfjA/v-deo.html
Brilliant video. Thanks Christine, learnt the skill of use of bookmark from this video today.
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.
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 :)
brilliant, this just solved a huge issue I had with my report! thank you!!
Great to hear!
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!
Simple but powerful solution. Helped me greatly.
This was a huge help on getting the sorting right! Thank you!
Awesome!
This is genius, thank you so much!!
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.
Cool video. Thanks for sharing.
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.
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
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!
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.
that is absolutely brilliant! thanks
Hi, Does this work with a matrix ?
Yep, it’ll work with all visuals!
@@bi-ome Thanks !
I couldn't find part 2 of the video, is that available?
Edit: I found it 😊
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, im dizzy when i create field parameters it show that coding stuff 😂 i will try follow your method to fix that thing.
The field parameters are one of the best features of Power BI, totally worth getting into the coding stuff! You don't even have to write the code yourself, it writes it for you. 😄
Great content as always-
You should be able to sort your parameters without creating bookmarks by creating a selected value type measure. Create this measure and put it in your tool tip- then you should be able to use the 'sort by' by clicking the ellipsis and can select measure you put in your tool tip. A measure like this for example:
Prm: Sort Selected Measure =
SWITCH(
MAX( Prm_Measure_Switch[Prm_Measure_Switch] ),
"Sales Amount", [Sales Amount],
"Sales Quantity", [Sales Quantity]
)
That should stick when clicking between parameters. Credit to Bas: ua-cam.com/video/rx_vq1jgfjA/v-deo.html
That's a great tip!