March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
10-03-2022 11:23 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
@uttahjazz , Shared in my comment.
Thanks Amit - thanks for the demo, I didn't realize that this was quite this powerful!
Proud to be a Datanaut!
Private message me for consulting or training needs.
I really like the way field parameter is being used in a slicer and one thing I want to Implement right away is to show which one is parameter selected by using the swtich condition. Thanks for that amit.
can you wrote the dax for the selected value?
Please check the file shared
Code is
Selected Parameter = maxx(filter(Parameter ,Parameter[Parameter Order] = SELECTEDVALUE(Parameter[Parameter Order])), Parameter[Parameter])
This is truly amazing. Use of this slicer has really cut down work time for me.
Thank you for the demo,
Obviously, you need to be good with DAX to achieve many of the tricks being presented.
Question: Can you talk about how the performance is effected by using field parameters please?
Thanks. Need to do more with Field Parameters.
nice one
Welcome to the show! Please ask your questions here to be eligble for this month's giveaway - Power BI Socks.
Great demo! Can you provide the pbix file for us to review please with the video? TIA ⭐⭐⭐⭐⭐
Thanks @amitchandak for posting a notice on LinkedIn! Just in time!!! See you in 60 minutes ⭐⭐⭐⭐⭐