Power BI Community Show Episode 10-Making Your Power BI Reports More Dynamic using Field Parameters 10-03-2022 08:16 AM - last edited 01-30-2023 09:17 AM

[Natalie_iTalent]

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

[BimalSubhasis]

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

[kmsmith1108]

This is awesome.  Thank you so much.  Placing the Axis Slicer in the Legend is very convenient also.  

[HRM5]

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!!

[tamerj1]

Excellent illustration. Thank you @amitchandak 

[amitchandak]

Thanks, @tamerj1 . You are doing a great job in the community. Thanks for that too.

[StaceyR]

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.

[amitchandak]

@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.

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

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

[PabloDeheza]

Thank you for sharing!

[berntmagne]

Field parameters is a game changer, thanks for sharing!

[J_Sekellick]

This is such a great group. Great updates. It'd be great to find a group in my area.

[elaine_dunwoody]

Thank you for showing us how to do the [SelectParameter] measure!

[yakaba]

I will try out a visualization in which both axis are field slicers. This will give users option exploring different scenarios without switching pages.

[ImranAhmed2507]

I am hoping to learn a lot from peeps around and share my experience as well. 

[amitchandak]

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.

[AzizQuazi]

You are great, @amitchandak, I was looking at these PBI files. Thanks.

Rgds...Aziz

[uttahjazz]

Thanks for sharing this

[ImranAhmed2507]

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.  

[Dinesh_nk711]

Great show. 

[papi]

Wow, I was using bookmarks many times and never heard about field parameters. This is so great! Thank you.

[uttahjazz]

will the pbix file be shared ?