Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
10-03-2022 08:16 AM - last edited 01-30-2023 09:17 AM
Welcome to the Power BI Community Show! This is a live show hosted by Kelly Kaye, the Community Engagement Lead for Power BI. She is passionate about the Power BI Community, is the founder of the Power BI Women User Group, and a Power BI developer.
On this episode, Kelly Kaye interviews Amit Chandak, a Power BI Super User who will demo how to use Field Parameters to make reports more dynamic.
Connect with Kelly on Twitter: @MS_KellyKaye
Connect with Amit on Twitter: @achandak78
Follow Amit on YouTube: Amit Chandak - YouTube
Connect with Amit on LinkedIn: https://www.linkedin.com/in/amitchandak78/
Each Power BI Community show features different topics, speakers, and giveaways celebrating the awesome Power BI Community. We invite you to join us for this and past episodes. Post your comments on https://aka.ms/PBIShowComment, so we can contact you if you are selected for a giveaway item!
Show Links:
• Register on the Power BI Community: https://community.powerbi.com/ for fun giveaways
• Connect with a Power BI User Group: https://aka.ms/PowerBIug
• Check out past episodes of the Power BI Community Show: https://aka.ms/PowerBIShow
watch?v=gae11ITerTU
Thanks for the detailed explanation.
I would like to understand how to make field parameters work in PBI Desktop connected live with SSAS cube.
I do agree there is certain limations on the live connection where all of the edit options are greyed out.
Let me know if there is any alternate thought.
Thanks,
Bimal
This is awesome. Thank you so much. Placing the Axis Slicer in the Legend is very convenient also.
Hi,
Community!! and @amitchandak
Thanks for your ideas and Power BI features we are lucky that we have incredible people like you.
Its a great game changer feature in Power BI.
Thanks to everyone!!
Thanks, @tamerj1 . You are doing a great job in the community. Thanks for that too.
What if your totals are different formats? You want for example a sum of sales ($), total quantity (#), and percent total (%) - will the field parameter account for this on the axis and show correctly? All the examples I've seen so far are for numbers only or percents only across all fields chosen.
@StaceyR , if you use only the measure slicer. It will take care of the measure format. In this example, I have both % and number together.
Make sure the format option of measure is used. (Under measure tools or under property pane of data model)
But if you create a measure on the top of the measure slicer measure, it might not work as the measure can have a single format.
for such cases use calculation groups
Thank you for sharing!
Field parameters is a game changer, thanks for sharing!
This is such a great group. Great updates. It'd be great to find a group in my area.
Thank you for showing us how to do the [SelectParameter] measure!
I will try out a visualization in which both axis are field slicers. This will give users option exploring different scenarios without switching pages.
I am hoping to learn a lot from peeps around and share my experience as well.
Please find the files from show.
1. Field Parameter - The one I used during Demo
2. TOPN - The TOPN Switch
3. Combine - Both Measure and Dimension Slicer.
Thanks for sharing this
I'm quite amazed st the way how field parameters can make our lives easy. It's an amazing alternative to using bookmarks as slicer.
And the icing on the cake was color slicer as shown by Amit. Kudos to Amit. Keep up the good work.
Great show.
Wow, I was using bookmarks many times and never heard about field parameters. This is so great! Thank you.
will the pbix file be shared ?