Fields Parameter in Action I Practical Examples

Рет қаралды 118,202

Күн бұрын

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 support@datatraining.io
---------------------------------
⏱️ 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 KZfaq: 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

Пікірлер: 316

@04mdsimps Жыл бұрын

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

@DawnPeacockOwens 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@tigsik3128 2 жыл бұрын

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!

@pilarbaldominos2505 2 жыл бұрын

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!

@hi55us2 2 жыл бұрын

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.

@jordanpetty4356 2 жыл бұрын

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!

@PedroCabraldaCamara 2 жыл бұрын

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

@ilfacone 2 жыл бұрын

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 2 жыл бұрын

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

@tinaflemons263 2 жыл бұрын

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

@rauljimenez5485 2 жыл бұрын

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

@anuppatil4444 2 жыл бұрын

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

@608er 11 ай бұрын

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

@JustRandomExplorer 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@alex...g 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

thank you Alex! definitely more coming on this one 😀

@kenmuir3174 2 жыл бұрын

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 2 жыл бұрын

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

@rajarshisingh2547 Жыл бұрын

best video on fields parameter so far

@raeesg 2 жыл бұрын

Game changing, well done PBI team!

@HowtoPowerBI 2 жыл бұрын

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

@terpstry 2 жыл бұрын

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 2 жыл бұрын

Happy to hear it helped solving your issue :)

@julienbouillot6960 11 ай бұрын

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 🙂

@morris5984 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Thanks Bryan :) hope your team also likes it !

@PhaLeCaoHoang 2 ай бұрын

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

@HowtoPowerBI 2 ай бұрын

Glad it was helpful!

@asgerlarsen2083 2 жыл бұрын

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 2 жыл бұрын

Great Idea, thanks for sharing

@asgerlarsen2083 2 жыл бұрын

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?

@just_pbi 11 ай бұрын

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!

@AndreaRodriguez-mj2os Жыл бұрын

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

@ftmagicart Жыл бұрын

Amazing demonstration. Thank you very much for this tutorial.

@bennydelight4454 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Glad to hear this Ben, thanks!

@BaldBookTuber 2 жыл бұрын

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 2 жыл бұрын

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

@fabiokyrilloss 2 жыл бұрын

You're the best! Cheers from Brazil.

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

@ofentsekoolopile4811 2 жыл бұрын

15 MINS well spent ! Thanks Bas !

@HowtoPowerBI 2 жыл бұрын

thanks 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

@alicedwonderland7733 2 жыл бұрын

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 2 жыл бұрын

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

@cityoflaredoopendatadivisi9197 Жыл бұрын

Exactly the solution I needed. Thank You.

@luismenjivar1985 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

that is really great to hear thanks a lot! 😊

@christianbauermeister6266 7 ай бұрын

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

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

@fernandonichele4489 9 ай бұрын

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

@simonloughnane6683 2 жыл бұрын

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 2 жыл бұрын

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

@rauljimenez5485 2 жыл бұрын

Great addition to the options of use!!

@PeterKontogeorgis 2 жыл бұрын

Brilliant feature and content Bas! As always.

@iuliacostinas8074 Жыл бұрын

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

@unnikrishnansanthosh 2 жыл бұрын

excellent as always, thank you BAS for sharing

@ricardocontreras 2 жыл бұрын

Amazing!..thank you!!

@bensalemyoussef2444 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

thx!!! 😎😊

@spen2431 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

double thanks for watching my videos 2 times 😀😁

@katslog 2 жыл бұрын

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

@shashipaul6279 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@Sideshowgaz5779 2 жыл бұрын

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 :-)

@DiabolicSoundz Жыл бұрын

Fijn om bij te leren van een Belg ! Geweldige videos

@AJM2183 2 жыл бұрын

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

@DavidElkjr 2 жыл бұрын

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

@keagankemp6275 Жыл бұрын

Love this parameter wow I love this channel thanks Bas

@lijunchen Жыл бұрын

Great tutorial! Keep on the good work, Bas.

@jlopezbe 3 ай бұрын

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 !

@alirezamogharabi8733 Жыл бұрын

Really helpful, I learned a lot thank you ❤

@PHILIPROYBENEDICTLOUIS 2 жыл бұрын

Useful Video. Thank you Bas

@AHMEDALDAFAAE1 2 жыл бұрын

Thank you so much!

@TrassBI 2 жыл бұрын

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

@NoseBreather 2 жыл бұрын

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 :-/

@antique-bs8bb 2 жыл бұрын

Brilliant - and you found a way to make it complicated again at the end!! I know you are not the Microsoft feedback board, but it would have been nice if we could edit the Field Parameter as easily as we can create it - Lo Code. Soon perhaps - good to get this thing out. Interesting - the parameter options are shown in a conventional filter visual. If you hit the rubber (clear the filter) sometimes you can get all the parameters at once. So for an example a column Chart allowed me to show all 5 different Sales/Quantity/profit measures I had made, each with its own column in a group for that product category. Which could be cool for the right moment. Whereas the parameter for dimensions: category/color/model would only give me one option only - defaulting to the first in the list. And I couldn't find a way to get just 2 or 3 Sales measures - it was all 5 or just 1.

@HowtoPowerBI 2 жыл бұрын

100% agree - hope somebody from microsoft reads this ;) .. I think you are able to select as many measures as you want from the parameter, not sure why it doesnt work for you.

@SolidSnake59 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@Luis.C.Canchan 2 жыл бұрын

Excelente herramienta, gracias Bass.

@HowtoPowerBI 2 жыл бұрын

thx Luis! ☺

@sadyaz64 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Glad to hear that! thank you so much 😊

@JTIJ 2 жыл бұрын

Bedankt Bas, wederom een duidelijke video. Dankjewel!

@HowtoPowerBI 2 жыл бұрын

Dankjewel!!! 😊

@datanerd6935 2 жыл бұрын

You're a lifesaver! Keep it up man.

@HowtoPowerBI 2 жыл бұрын

Happy you found it helpful:):)

@sudhirsimson3340 2 жыл бұрын

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 2 жыл бұрын

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?

@japumon 2 жыл бұрын

Wow this is amazing

@naylord5 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@joattangomesaquino7108 Жыл бұрын

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

@enocharthur4322 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Thanks a loooot!!!

@Rvdl89 2 жыл бұрын

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

@alpesh417rt Жыл бұрын

This is so cool - keen to implement asap

@HowtoPowerBI Жыл бұрын

Good luck!🍀

@Iamcorky12 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@jonesPossibly 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@pedja2518 2 жыл бұрын

As always, amazing video! Thnx!

@HowtoPowerBI 2 жыл бұрын

Thanks 🙏

@mutumakimathi Ай бұрын

You are a gem!

@christianhansson4580 2 жыл бұрын

This is seriously great! However I think it is good to mention that this doesn't work with Direct Query :) Which is quite common if you are working in a bigger enterprise environment.

@wanggang2396 2 жыл бұрын

Very useful features, Best explanation!

@HowtoPowerBI 2 жыл бұрын

Thank you!!! 😊

@nbandeiras 2 жыл бұрын

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

@HowtoPowerBI Жыл бұрын

Ahhah hillarious Nuno! Thanks :)

@sukoi2113 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

thx for watching again Rajneesh!!! 😊

@kostaskolotouros4345 2 жыл бұрын

Great video and great new feature! Happy days!

@HowtoPowerBI 2 жыл бұрын

Agree, finally full flexibility with axis! :)

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

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

@sravankumar1767 2 жыл бұрын

Nice explanation 👌

@bernardjacobs518 2 жыл бұрын

Hi Bas. This is HUGE - thanks for the heads-up and suggested use cases for the FIELDS PARAMETER feature that has been added. I have a question for you and hopefully you are able to provide a solution. I have successfully managed to implement the parameter selection as you have shown in the demo. What I am trying to do is the following scenario. I have one parameter for the "numerator" and a second parameter for the "denominator". What I would like to do is to use the results of "numerator" divided by the "denominator" in a separate measure. I have tried a few options but i seem to come up with the following error message: Column [NumeratorParameter] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression. In the mean time Have a POWER day 💪

@hainsay 2 жыл бұрын

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?)

@jawadahmadehssan6251 2 жыл бұрын

Thanks Bas, it really is a game changer feature.

@HowtoPowerBI 2 жыл бұрын

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

@EYEmaginary 2 жыл бұрын

Great this feature is here!

@damionc 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

:) let me know how you like it

@gopinathn9059 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

awesome!! 😎

@ezekiel0606 2 жыл бұрын

amazing video. thank you!

@HowtoPowerBI 2 жыл бұрын

thank you so much for watching Ezekiel! 😊

@rdg515 2 жыл бұрын

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

@leukep 2 жыл бұрын

Great video! Not a big fan of a calculated column for a top 10 of products though! Works for the example, but in most cases might give wrong insights with multiple active filters on your canvas.

@SemogOlecram 2 жыл бұрын

Usually I use a measure with rankx inside a calculate with keepfilters

@brundleseth51 2 жыл бұрын

Justo el video que estaba esperando 👌

@HowtoPowerBI 2 жыл бұрын

gracias por mirar! 😀

@manojprabhakar7951 4 ай бұрын

Brilliant Bas👏👏👏

@renataaugustinova1399 2 жыл бұрын

Thank you so much, very usefull.

@HowtoPowerBI 2 жыл бұрын

Thx Renata! Glad you think so

@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

@rainerstehr 2 жыл бұрын

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