Fields Parameter in Action I Practical Examples
Vložit
- čas přidán 22. 07. 2024
- 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 CZcams: 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 - Věda a technologie
This guys just earned himself a follower. No dramatic nonsense just simply talking through his actions and thought process. Brilliant
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.
Mind BLOWN! Thank you! I have been using tons and tons of bookmarks. This is going to make my life a lot easier!
thanks for watching Dawn! My life definitely also got easier cause of this update 😀😊😁
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!
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
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.
aaaah that's where all the views r coming from 😁 thanks a lot for watching my videos Christoper!
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!
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!
Spectacular use cases and Ideas on how to adjust and expand those uses!! Thank you!
Simply amazing. Thank you for the examples. I can't wait until you come up some other creative ways to use the new feature
This really seems to be a game changer from Power BI. Absolutely required and very very useful to reduce the complexity from the reports
I’m consistently sharing your videos with my team. You are a fantastic educator.
Thanks Bryan :) hope your team also likes it !
FINALLY! Been waiting this to be finally included in Power BI. Thanks for great video!
me 2! took a lot of waiting, but it sooo good!😊
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.
Happy to hear it helped solving your issue :)
These are by far the best PowerBI videos I’ve come across
Glad to hear this Ben, thanks!
It is an amazing way to optimize the dashboard. Thank you!!!
Glad it was helpful!
Parameters are insane. Just found them and they help sooooo much. Thank you for the video!
Great video. Super powerful feature. Thanks for sharing. Can't wait to see what else you come up with!
thank you Alex! definitely more coming on this one 😀
Game changing, well done PBI team!
Indeed is game changing, Big feature that was missing! 😀
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!
Amazing demonstration. Thank you very much for this tutorial.
this is amazing! i'm so over using bookmarks to toggle between visuals. great tutorial.
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.
Great Idea, thanks for sharing
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.
@@asgerlarsen2083 What type of applications were you thinking?
best video on fields parameter so far
15 MINS well spent ! Thanks Bas !
thanks for watching!!! 😊
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 🙂
Probably the most excited I've been about a new update in Power BI ever tbh. Can't wait to dig in with this.
yea same here, one I was waiting for since a long time
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!
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
Great! exactly what I needed … and how I needed it. thanks👍
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.
You're the best! Cheers from Brazil.
You are very good at what’s you do! Tks 😊
Awesome feature - awesome content! ❤ Thank you for creating this video!🎉
Exactly the solution I needed. Thank You.
Customizing fields on field parameter is very useful for creating dynamic drill down matrix. Thank you for creating this video🎉❤
Thanks Heramb for watching!
Brilliant feature and content Bas! As always.
Great tutorial! Keep on the good work, Bas.
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!!
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!!!
excellent as always, thank you BAS for sharing
This is incredible just an awesome and clean video Bas!. Dont give up and keep it up, we appreciate all your content :) :) :)
that is really great to hear thanks a lot! 😊
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 😎
Super Sarvesh :) thanks for watching
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
I agree with 👇👇. I always watch, then re-watch your videos. Thanks for sharing. 👍 💥
double thanks for watching my videos 2 times 😀😁
Excelente herramienta, gracias Bass.
thx Luis! ☺
Really helpful, I learned a lot thank you ❤
As always, amazing video!
Thnx!
Thanks 🙏
That's really great presentation n option provided via Microsoft POWER BI indeed........
my favorite update so far for the year! 😊thx Shashi
Love this parameter wow I love this channel thanks Bas
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 :-/
Useful Video. Thank you Bas
You're a lifesaver! Keep it up man.
Happy you found it helpful:):)
thank you, we always learn some thing new in this channel
Glad to hear that! thank you so much 😊
Great video and great new feature! Happy days!
Agree, finally full flexibility with axis! :)
Bro you are awesome
Thank you for sharing all this with us
thx!!! 😎😊
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 :-)
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.
That's a great idea! thanks for sharing! 😀
Great addition to the options of use!!
Muito bom seus videos Bas, conteudo incrivel chegando aqui no Brasil!
This is so cool - keen to implement asap
Good luck!🍀
Fijn om bij te leren van een Belg ! Geweldige videos
Super useful and impressive content made by you. Thank you very much
thx for watching again Rajneesh!!! 😊
This is a game changer. Great update and great video !
totally is - I'm loving it - curious to see all the different applications people come up with .. thx for watching! 😊
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).
Thank you so much!
Great! That's something I have been missing in PowerBi.
me 2!! I'm loving this new feature 😀
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 :)
I am happy to hear you like the format! Thanks for watching:)
Thanks Bro this video is very useful. I have implemented in my reports.
awesome!! 😎
Very useful features, Best explanation!
Thank you!!! 😊
Bas Thank you so much. You are the Power BI Boss ;)
Ahhah hillarious Nuno! Thanks :)
Have I told you how amazing you are yet? I love your illustrations... Just on point!!!
Thanks a loooot!!!
amazing video. thank you!
thank you so much for watching Ezekiel! 😊
Amazing!..thank you!!
You are a gem!
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
This is amazing feature!🪄🪄🪄Thanks for sharing.🙂
Awesome presentation Bas, it will help in one of the projects which are in the design stage.
Glad to hear this Gaurav!
@@HowtoPowerBI Cheers and respect from Indian fan
looks like it could be perfect for selecting between set date ranges. all sorts of things. great feature and nice video, Bas.
definitely is! still working on different use cases - I love it! thx for watching 😊
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?
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?
A little bit late, but have you tried with HASONEVALUE?
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).
Thanks Bas, it really is a game changer feature.
such a big update - really a feature power bi was missing
Wow this is amazing
Bedankt Bas, wederom een duidelijke video. Dankjewel!
Dankjewel!!! 😊
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 !
Justo el video que estaba esperando 👌
gracias por mirar! 😀
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?)
Maaaannnn !!!
What a awesome video, and a really truly mega super useful tips...
Like Dawn said before, mind blown !!!
If I got more confidence on my skills like this, I don't know what could be possible.
Thanks Rodney! Time to grow the skills/confidence and see where it takes you :) keeping fingers crossed for you my friend!
It's amazing 😊
Nice tricks. I am glad you share....
:) thanks Nitin!
Thank you for this presentation.
It works well for diagrams, but it has a bug for tables. If you put the field parameter in a table, the sorting is changed to default every time you choose one of the options in the slicer.
I want to show the amount in descending order and when I change to % of total, to have the percentage in descending oder as well, but it is changing. Do you have a solution for this?
Thank you so much, very usefull.
Thx Renata! Glad you think so
Wow! This is simply amazing! Time to refactor mi prev reports 😅😂
😅I feel your pain .. guess I also have work to do haha
Wow. Nice. I am going to use it now.
:) let me know how you like it
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.
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.
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.
This is great! Thank you! I still have a problem with the totals.
with absolute values the totals is ok, but when I switch to percentage the total show up as 1 instead of 100%.
Do you have a solution for that?
I tried to like twice but it backfired so I liked three times.👍👍👍
This cool, thanks!
thank you!! 😊
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 💪
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.
Amazing detailed well explained and enjoyable pacing and graphic work. A lot of work and thought going on here in prep. 🌏
Glad it was helpful! Thanks for the positive feedback:)
Awesome explanation...😇
Thanks Bharath!