Level Up your Power BI Game with Field Parameters! (with Nikola Ilic)

[@workstuff5253]

Hi Reid. I wasn't clear if the video already exists or not, but I'd love to see you demo the technique you were describing @1:04:11. Cheers

[@HavensConsulting]

This one one of them, using the field parameter order column as a key :) kzbin.info/www/bejne/gXiUhJJtd9Gkd7s

[@arunwats]

Thanks for this. I am displaying a table via drill through with set of limited columns. If a set of users login then I want to give them an option to select “limited/all” fields via field parameter else only limited option should be visible. how can I achieve.

[@ThePilli41]

Amazing video! just a quick shout out to both Nikola and Reid, below is the Treatas formula: Sel Value = VAR SelectedValue = SELECTCOLUMNS ( SUMMARIZE ( 'Param Treatas', 'Param Treatas'[Param Treatas], 'Param Treatas'[Param Treatas Fields] ), 'Param Treatas'[Param Treatas] ) RETURN "Selected value from FP is: " & IF ( COUNTROWS ( 'Param Treatas' ) = 1, MAX ( 'Param Treatas'[Param Treatas] ) ) // (COUNTROWS(_SelectedValue),_SelectedValue)

[@carltonseymour869]

Awesome examples showcasing Field Parameters

[@HavensConsulting]

Glad you liked it!

[@carltonseymour869]

I actually used in in a project and worked like MAGIC@@HavensConsulting

[@scramiro1]

Can anybody point me to a video o blog explaining how to retain a hierarchy expanded when changing the selection of the field parameters.. I've read you can, but can't find the how to with details. Thanks

[@HavensConsulting]

That would be news to both Nikola and I. As neither of us has seen a way around this limitation. It was the topic of the field parameters vs calculation groups video I did a few weeks ago, and that having the hierarchy below a field parameter reset, because the structure of the query changes.

[@muhammetmuslu4429]

I love field parameter more now.thank you

[@HavensConsulting]

Great to hear!

[@LucaGanugi]

Another great usage of field parameter is to let the user to customize ad hoc a matrix for example, just letting them to select what dimensions to see and in what order. If you multiselect some values inside the field parameter, those dimensions are displayed in the very same order as you click, letting to dinamically change grouping.

[@HavensConsulting]

Absolutely, it's essentially what I showcase in this video I released a few weeks back :) kzbin.info/www/bejne/oqqZZH5snp6ors0

[@VijayYadav-tx6ft]

Could you please me how can use multiple fields parameters with help of data modeling

[@HavensConsulting]

Hi there! Could you elaborate on your question? What do you mean by "using multiple field parameters"?

[@powerbinareal]

Urra!!!!!

[@JBartlett_DMU]

Hey Reid, I just found out that it's possible to create Field Parameters with a Tabular Editor script, so you're not limited to only creating them in Power BI Desktop anymore. GIAC did a video demonstrating the technique back in January, and it's called "Can you use Field Parameters with Direct Lake in Power BI?": kzbin.info/www/bejne/eZiZq4WerKtgiNE

[@HavensConsulting]

Heck yeah, thanks for that!