Fields Parameter in Action I Practical Examples

In this video I show you all you need to know to start using fields parameters in Power BI. This new type of parameter enables you to choose from different fields or measures. When used on the axis, legend or values the user can toggle between the different fields that you add to the parameter.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:45 Getting started with field parameters
04:06 Making adjustments to an existing parameter
05:19 Using a field parameter on the legend
06:03 Switching between measures with a field parameter
08:55 Customized fields on a field parameter
14:56 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZbin: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[@04mdsimps]

This guys just earned himself a follower. No dramatic nonsense just simply talking through his actions and thought process. Brilliant

[@DawnPeacockOwens]

Mind BLOWN! Thank you! I have been using tons and tons of bookmarks. This is going to make my life a lot easier!

[@HowtoPowerBI]

thanks for watching Dawn! My life definitely also got easier cause of this update 😀😊😁

[@ilfacone]

I love the way you present these videos Bas. I have to watch them a few times to get all the information out of them as they're so rich in value. Brilliant stuff.

[@HowtoPowerBI]

aaaah that's where all the views r coming from 😁 thanks a lot for watching my videos Christoper!

[@hi55us2]

Still my favorite Power BI channel and timely advice with the update that just came out. This is going to make so many of my reports better in combination with the new Page/Bookmark navigator.

[@pilarbaldominos2505]

Thanks Bas! I was waiting for an easy way to this for sooo long, it is going to save me a lot of time! Thanks for being so fast to show us this new feature!

[@tigsik3128]

this is the best update from power bi . I used to do this using Dax and Selected Values etc. but field parameters is a game changer! Thanks for the great content!

[@rauljimenez5485]

Spectacular use cases and Ideas on how to adjust and expand those uses!! Thank you!

[@jordanpetty4356]

Man glad I watched this video! This is a game changer to make everyone’s lives easier! 😃 also allows anyone to consolidate multiple visuals/pages into one!

[@morris5984]

I’m consistently sharing your videos with my team. You are a fantastic educator.

[@HowtoPowerBI]

Thanks Bryan :) hope your team also likes it !

[@PedroCabraldaCamara]

Beautiful presentation of this video Bas. You're truly are in this business to help us and teach us Power BI. I'm so glad that your video was the first after Microsoft's update. Thank you so much Bas

[@PhaLeCaoHoang]

It is an amazing way to optimize the dashboard. Thank you!!!

[@HowtoPowerBI]

Glad it was helpful!

[@bennydelight4454]

These are by far the best PowerBI videos I’ve come across

[@HowtoPowerBI]

Glad to hear this Ben, thanks!

[@raeesg]

Game changing, well done PBI team!

[@HowtoPowerBI]

Indeed is game changing, Big feature that was missing! 😀

[@tinaflemons263]

Simply amazing. Thank you for the examples. I can't wait until you come up some other creative ways to use the new feature

[@ofentsekoolopile4811]

15 MINS well spent ! Thanks Bas !

[@HowtoPowerBI]

thanks for watching!!! 😊

[@ftmagicart]

Amazing demonstration. Thank you very much for this tutorial.

[@rajarshisingh2547]

best video on fields parameter so far

[@anuppatil4444]

This really seems to be a game changer from Power BI. Absolutely required and very very useful to reduce the complexity from the reports

[@JustRandomExplorer]

FINALLY! Been waiting this to be finally included in Power BI. Thanks for great video!

[@HowtoPowerBI]

me 2! took a lot of waiting, but it sooo good!😊

[@608er]

Parameters are insane. Just found them and they help sooooo much. Thank you for the video!

[@fabiokyrilloss]

You're the best! Cheers from Brazil.

[@just_pbi]

Wow this is one of the most useful videos I've watched! Well done! I'm definitely going to use this going forward! Thank you for sharing!

[@cityoflaredoopendatadivisi9197]

Exactly the solution I needed. Thank You.

[@terpstry]

Once again, a helpful video. Thanks a million. I was struggling with the TOP N filtering using Field Parameters, but this video contains the solution.

[@HowtoPowerBI]

Happy to hear it helped solving your issue :)

[@AndreaRodriguez-mj2os]

this is amazing! i'm so over using bookmarks to toggle between visuals. great tutorial.

[@fernandonichele4489]

You are very good at what’s you do! Tks 😊

[@alex...g]

Great video. Super powerful feature. Thanks for sharing. Can't wait to see what else you come up with!

[@HowtoPowerBI]

thank you Alex! definitely more coming on this one 😀

[@christianbauermeister6266]

Great! exactly what I needed … and how I needed it. thanks👍

[@iuliacostinas8074]

Awesome feature - awesome content! ❤ Thank you for creating this video!🎉

[@unnikrishnansanthosh]

excellent as always, thank you BAS for sharing

[@Luis.C.Canchan]

Excelente herramienta, gracias Bass.

[@HowtoPowerBI]

thx Luis! ☺

[@lijunchen]

Great tutorial! Keep on the good work, Bas.

[@julienbouillot6960]

Very entertaining and informative as always. I was looking at using parameters for a specific application to use for a radar chart.I have a data table that contains a first column with dimensions and about 100 columns with the product names that contain the score against each dimension. What I am trying to do is to create a 2 column table from that would contain the dimensions in the first column. and the desired selected product in the second table to set up the radar chart.... Hopefully this will get your creative juices going for another great video helping me in the process 🙂

[@PeterKontogeorgis]

Brilliant feature and content Bas! As always.

[@keagankemp6275]

Love this parameter wow I love this channel thanks Bas

[@alirezamogharabi8733]

Really helpful, I learned a lot thank you ❤

[@spen2431]

I agree with 👇👇. I always watch, then re-watch your videos. Thanks for sharing. 👍 💥

[@HowtoPowerBI]

double thanks for watching my videos 2 times 😀😁

[@pedja2518]

As always, amazing video! Thnx!

[@HowtoPowerBI]

Thanks 🙏

[@BaldBookTuber]

Probably the most excited I've been about a new update in Power BI ever tbh. Can't wait to dig in with this.

[@HowtoPowerBI]

yea same here, one I was waiting for since a long time

[@luismenjivar1985]

This is incredible just an awesome and clean video Bas!. Dont give up and keep it up, we appreciate all your content :) :) :)

[@HowtoPowerBI]

that is really great to hear thanks a lot! 😊

[@kenmuir3174]

Result! Parameters is the main thing I missed from Tableau when I moved to Power BI, switch functions and views were so time consuming, this will have such an impact. Great video!

[@HowtoPowerBI]

thanks Ken! I know, with parameters (and parameter actions) in tableau you can do amazing visuals - I'm happy that power bi now is slowly filling that gap compared to tableau

[@PHILIPROYBENEDICTLOUIS]

Useful Video. Thank you Bas

[@DiabolicSoundz]

Fijn om bij te leren van een Belg ! Geweldige videos

[@shashipaul6279]

That's really great presentation n option provided via Microsoft POWER BI indeed........

[@HowtoPowerBI]

my favorite update so far for the year! 😊thx Shashi

[@datanerd6935]

You're a lifesaver! Keep it up man.

[@HowtoPowerBI]

Happy you found it helpful:):)

[@bensalemyoussef2444]

Bro you are awesome Thank you for sharing all this with us

[@HowtoPowerBI]

thx!!! 😎😊

[@kostaskolotouros4345]

Great video and great new feature! Happy days!

[@HowtoPowerBI]

Agree, finally full flexibility with axis! :)

[@vishnew89]

Customizing fields on field parameter is very useful for creating dynamic drill down matrix. Thank you for creating this video🎉❤

[@HowtoPowerBI]

Thanks Heramb for watching!

[@sarveshdeshpande1772]

This is impressive!!!! It was tough using selected value and creating tables or using bookmarks to achieve this. This is life saver. 👍 I am your top fan now 😎

[@HowtoPowerBI]

Super Sarvesh :) thanks for watching

[@DavidElkjr]

really amazing, thank you for a great video. How would you keep a custom sort on the parameter on the x-axis? Sorting gets reset every time a slicer selection is changed

[@ricardocontreras]

Amazing!..thank you!!

[@Simon-vc1wk]

Really nice video. I've implemented these into a report I'm developing, which has helped as you say Bas to help eliminate calculation groups, bookmarks, edit interactions to change a graph dynamically. Two thins I couldn't get fully working was dynamically titles, as it displays the table name of my field parameters. The second was a dropped the field para ammeter into a matrix which dynamically updated values in the table with the selected measures in the slicer but my previous conditional formatting for my previous tables are not working in the field parameter version of the table.

[@asgerlarsen2083]

Great video! Another awesome feature with the Fields Parameters is that it allows you to create column names based on an expression, for example in the matrix visual. This works by simply replacing the column name text in the Field Parameter DAX expression with an expression or measure of your choice. This has so many applications. This was absolutly mindblowing for me since I have been searching for a way to do this for quite a while.

[@SemogOlecram]

Great Idea, thanks for sharing

[@asgerlarsen2083]

After testing it a bit, I found that it is a bit more restricted than I anticipated. For example, I couldn't get SELECTEDVALUE() to work, but the CALCULATE() function seems to work fine in the cases I tested.

[@brandonm2099]

@@asgerlarsen2083 What type of applications were you thinking?

[@AHMEDALDAFAAE1]

Thank you so much!

[@naylord5]

Wow! This is simply amazing! Time to refactor mi prev reports 😅😂

[@HowtoPowerBI]

😅I feel your pain .. guess I also have work to do haha

[@sadyaz64]

thank you, we always learn some thing new in this channel

[@HowtoPowerBI]

Glad to hear that! thank you so much 😊

[@alpesh417rt]

This is so cool - keen to implement asap

[@HowtoPowerBI]

Good luck!🍀

[@wanggang2396]

Very useful features, Best explanation!

[@HowtoPowerBI]

Thank you!!! 😊

[@nbandeiras]

Bas Thank you so much. You are the Power BI Boss ;)

[@HowtoPowerBI]

Ahhah hillarious Nuno! Thanks :)

[@ezekiel0606]

amazing video. thank you!

[@HowtoPowerBI]

thank you so much for watching Ezekiel! 😊

[@Rvdl89]

Dank voor de goede video, Bas! Side note: je beweegt bij zoveel met je armen dat mijn zoontje van 2 dacht dat ik naar een dansvideo keek, en spontaan ging mee dansen met zijn armen! xD

[@enocharthur4322]

Have I told you how amazing you are yet? I love your illustrations... Just on point!!!

[@HowtoPowerBI]

Thanks a loooot!!!

[@Iamcorky12]

This is a game changer. Great update and great video !

[@HowtoPowerBI]

totally is - I'm loving it - curious to see all the different applications people come up with .. thx for watching! 😊

[@JTIJ]

Bedankt Bas, wederom een duidelijke video. Dankjewel!

[@HowtoPowerBI]

Dankjewel!!! 😊

[@alicedwonderland7733]

Fantastic as always, Bas! My reports are going to look so much better with less effort! Edit: it works brilliantly to switch between displaying columns as Years, Quarters, or Months in a matrix visual. No more switching to 'columns' then 'go to next level' using the Matrix options!!

[@alicedwonderland7733]

I can't see the option of changing the measure names for that particular visual though. That's a downside. Edit: I can! In the Prm, just change what's between the quotation marks! Also, you can choose to display EACH individual value as thousands of millions or with no units! This is the BEST update in a very long time!!!

[@simonloughnane6683]

Great video as always Bas. One thing I have tried which is really useful is using the parameter in the 'Small multiple' box. The user can then compare graphs by whichever dimension they want.

[@HowtoPowerBI]

That's a great idea! thanks for sharing! 😀

[@rauljimenez5485]

Great addition to the options of use!!

[@TrassBI]

This is amazing feature!🪄🪄🪄Thanks for sharing.🙂

[@NoseBreather]

Great content! Do you know if it's possible to create conditional formatting based on a field parameter? So that the conditional formatting applies to each measure that is selected? Not seeing that option right now :-/

[@sukoi2113]

Super useful and impressive content made by you. Thank you very much

[@HowtoPowerBI]

thx for watching again Rajneesh!!! 😊

[@renataaugustinova1399]

Thank you so much, very usefull.

[@HowtoPowerBI]

Thx Renata! Glad you think so

[@3danim8r1]

Nice tricks. I am glad you share....

[@HowtoPowerBI]

:) thanks Nitin!

[@SolidSnake59]

Great! That's something I have been missing in PowerBi.

[@HowtoPowerBI]

me 2!! I'm loving this new feature 😀

[@rdg515]

I tried to like twice but it backfired so I liked three times.👍👍👍

[@japumon]

Wow this is amazing

[@joattangomesaquino7108]

Muito bom seus videos Bas, conteudo incrivel chegando aqui no Brasil!

[@gopinathn9059]

Thanks Bro this video is very useful. I have implemented in my reports.

[@HowtoPowerBI]

awesome!! 😎

[@mutumakimathi]

You are a gem!

[@Sideshowgaz5779]

Another great video. Explained simply and what an amazing new feature. Unfortunately I am on Power BI Desktop (not cloud) and this is not included in the May 2022 release. At least that means I can wait 6 months before I need to re-write every report I have ever built :-)

[@alexandrewartel8771]

Hello Mr Bas ! thanks a lot for the many contents, many videos. Format is really clean. I enjoy it a lot. And yes indeed, this one new feature is 'clean' too :)

[@HowtoPowerBI]

I am happy to hear you like the format! Thanks for watching:)

[@mohitdhanotiya7567]

It's amazing 😊

[@sudhirsimson3340]

Great video. Yes, it's a big improvement as you have excellently explained how to use them. Thank you. I am not an expert in DAX, but wondering at 13:57 if we could use SELECTEDVALUE instead of MAX?

[@MariaMs96]

Hey, I tried but it is not working when using SELECTEDVALUE. This error message shows up: "Column [Parameter] is part of a composite key but not all columns of the composite key are included in the expression or its dependent expression". Bas could you help us, please?

[@naylord5]

A little bit late, but have you tried with HASONEVALUE?

[@sravankumar1767]

Nice explanation 👌

[@bharathsaikumar5519]

Awesome explanation...😇

[@HowtoPowerBI]

Thanks Bharath!

[@katslog]

After that evaluation of parameters BI close gaps from competitors ... :). More useful from drill through when you have too many categories etc. Thanks for video guide

[@jawadahmadehssan6251]

Thanks Bas, it really is a game changer feature.

[@HowtoPowerBI]

such a big update - really a feature power bi was missing

[@jlopezbe]

Thanks Bas, great video as always. Congrats for your work is remarkable. I am implementing the Top 10 Sales calculated column, but I am afraid the problem with the calculated columns is that it does not get filter context, so it does not dynamically calculates the Top 10 products, when the user filters Local, Products Category or Date table... It's so spectacular that I want to implement it as far as I find how to. Thanks !

[@EYEmaginary]

Great this feature is here!

[@damionc]

Wow. Nice. I am going to use it now.

[@HowtoPowerBI]

:) let me know how you like it

[@rainerstehr]

Thanks, again, for a very informative and clear video! Does this only work with text type fields? I have a table and would like the user to switch between showing prices or margins, for example. It kind of works, but shows the data only as text (therefore, does not allow number formatting).

[@gauravbrham7869]

Awesome presentation Bas, it will help in one of the projects which are in the design stage.

[@HowtoPowerBI]

Glad to hear this Gaurav!

[@gauravbrham7869]

@@HowtoPowerBI Cheers and respect from Indian fan

[@brundleseth51]

Justo el video que estaba esperando 👌

[@HowtoPowerBI]

gracias por mirar! 😀

[@AJM2183]

Great vid as usual mate. The only downside to this is ordering of the X axis. If I'm switching between weeks and days and periods, it forgets which order to put them in (other than for date).

[@gripro1]

This cool, thanks!

[@HowtoPowerBI]

thank you!! 😊

[@udusegbe]

Cool feature, great video 👍

[@HowtoPowerBI]

thank you Bare!

[@Bizza12345]

thanks mate great stuff

[@HowtoPowerBI]

Thanks a lot, happy to hear you like it!

[@dp6736]

Thanks for amazing videos. Since it is not easy to see numbers of screen, it will be nice if you allocate more or 100% of the screen area to the report instead of on you. Again, thanks for sharig your knowledge.

[@jonesPossibly]

looks like it could be perfect for selecting between set date ranges. all sorts of things. great feature and nice video, Bas.

[@HowtoPowerBI]

definitely is! still working on different use cases - I love it! thx for watching 😊

[@hainsay]

I've previously used bookmarks for changing axes and values. Do calculation groups have a significant use case now for another purpose or are they not really useful now? (Should I learn about them?)

[@nicoymartina]

Excellent!

[@HowtoPowerBI]

Thx Barbara!

[@Kevin-ex9vr]

man this is fantastic functionality