Fields Parameter in Action I Practical Examples

[@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 😀😊😁

[@bennydelight4454]

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

[@HowtoPowerBI]

Glad to hear this Ben, thanks!

[@nafeesahmed2642]

You are just awesome. 1000's of videos in youtube but the way you explain and show it practically, it just stands out. I applied it to my dashboard and it is looking very neat, as I dont have to show the same thing in multiple visualization. Thank you

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

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

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

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

[@raeesg]

Game changing, well done PBI team!

[@HowtoPowerBI]

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

[@andreashermle2716]

Bas, you are really a great presenter. Thank you

[@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?

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

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

[@rajarshisingh2547]

best video on fields parameter so far

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

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

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

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

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

[@ofentsekoolopile4811]

15 MINS well spent ! Thanks Bas !

[@HowtoPowerBI]

thanks for watching!!! 😊

[@608er]

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

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

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

[@morris5984]

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

[@HowtoPowerBI]

Thanks Bryan :) hope your team also likes it !

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

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

[@rdg515]

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

[@PhaLeCaoHoang]

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

[@HowtoPowerBI]

Glad it was helpful!

[@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 😀

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

[@fabiokyrilloss]

You're the best! Cheers from Brazil.

[@bernardjacobs518]

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 💪

[@omrigas]

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?

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

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

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

[@ftmagicart]

Amazing demonstration. Thank you very much for this tutorial.

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

[@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?

[@rauljimenez5485]

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

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

[@spen2431]

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

[@HowtoPowerBI]

double thanks for watching my videos 2 times 😀😁

[@AndreaRodriguez-mj2os]

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

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

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

[@antique-bs8bb]

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]

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.

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

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

[@enocharthur4322]

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

[@HowtoPowerBI]

Thanks a loooot!!!

[@datanerd6935]

You're a lifesaver! Keep it up man.

[@HowtoPowerBI]

Happy you found it helpful:):)

[@keagankemp6275]

Love this parameter wow I love this channel thanks Bas

[@christianhansson4580]

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.

[@romulusmilea2747]

Another interesting lesson ! An idea for a Field parameter would be to switch between Calendar months/years, and the Fiscal months/years. Many companies do use both calendar types, so I believe a separate video about it could be useful. Do you agree ?

[@HowtoPowerBI]

thank you! 😊 interesting application! I think for youtube the example is a bit too specific (and i got many vids on field parameters already)

[@lijunchen]

Great tutorial! Keep on the good work, Bas.

[@iuliacostinas8074]

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

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

[@OpenLessonsMy]

We can also create multiple copies of pmBreakdownList and thus allow users to change multiple aspects of the visual (rows AND columns, axis and legends, and even axis and legends and small multiples) at the same time. Layer in multiple types of visual, and basically we have the functionality of personalized visual without needing extra training of end users. Common selections can be saved as bookmarks that basically act as multiple pages while giving users clues how to customize the page. Also, I have tested adding a "category" field manually to the dax table codes, thus 1) Hierarchy Slicers - basically measure folders - but works even for dimensions and customizable across different tables 2) Easier to limit the selections for different pages / different reports connected live to the same database

[@leukep]

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]

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

[@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 🙂

[@bensalemyoussef2444]

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

[@HowtoPowerBI]

thx!!! 😎😊

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

[@PeterKontogeorgis]

Brilliant feature and content Bas! As always.

[@Luis.C.Canchan]

Excelente herramienta, gracias Bass.

[@HowtoPowerBI]

thx Luis! ☺

[@cicciogrecia]

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?

[@kostaskolotouros4345]

Great video and great new feature! Happy days!

[@HowtoPowerBI]

Agree, finally full flexibility with axis! :)

[@nbandeiras]

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

[@HowtoPowerBI]

Ahhah hillarious Nuno! Thanks :)

[@cityoflaredoopendatadivisi9197]

Exactly the solution I needed. Thank You.

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

[@analyticswithadam]

Quick question Bas. Why do we use MAX in the cals?

[@MélanieLarose-j5u]

I really like it! I did everything like in the video and it's work so fare but I want to add a slicer in the same page so the person will be able to chose office or not depending on his needs. The problem is the Filter for the blanck bar doesn't work anymore. What can I do to fix that ? Thanks

[@christianbauermeister6266]

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

[@DiabolicSoundz]

Fijn om bij te leren van een Belg ! Geweldige videos

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

[@unnikrishnansanthosh]

excellent as always, thank you BAS for sharing

[@rudreshgowdagowda2942]

Sir I am a big fan of you your presentation was amazing 😍

[@HowtoPowerBI]

Thanks Rudresh :)

[@tinaflemons263]

Great video, Can you do a video on how to summarize the field parameter to get the Top N of each so a Dynamic summary can be written. Allvselected and switch comes to mind but I'm unsure how to approach it.

[@iandrabble215]

Hi Bas, a feature I have found is that if you use 'Multi select with Ctrl' the order you select them from your slicer will be replicated as the order for 'drill down'.

[@laalaajonsen]

Amazing! Will try it out!

[@davelaff73]

This won't only make my life easier, this will make report users' lives easier!

[@HowtoPowerBI]

and mine 2!! 😁

[@Planeflake]

Great video, is it possible to use field parameters to choose which values are displayed in a matrix?

[@fernandonichele4489]

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

[@alirezamogharabi8733]

Really helpful, I learned a lot thank you ❤

[@MaestrosounD]

Very nice video, Bas. I see you use MAX() to evaluate a value in a specific field. Can you please explain to me why you use MAX() instead of SELECTEDVALUE()? What are the pro's and cons?

[@TainuiaKid1973]

I'm wondering this too.

[@marcvandewall804]

It's one of their best features added in 2022 by far. I'm only a tiny bit sad that it's only available for import mode, because I'm working with SSAS cubes (live connection), which seems to restrict these features. Do you think it's possible (with some sort of workaround) to use this feature in combination with SSAS cubes?

[@Najla-us6pz]

Thank you so much! Great video

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

[@hugarohugaro]

Great Video, is there a way to sort them differently the different field parameters. Example: Field Parameter 1, sort by measure A desc Field Parameter 2, sort by measure B asc

[@mirrrvelll5164]

Great video man! Question, is it possible to tweak those parameter measures table? adding some conditions and so on?

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

[@neilarnold129]

If I had a bar chart over time, can field parameters be used to switch between ‘this year’ and ‘next year’? Also can within the field parameter calculation, use CALCULATE and FILTER.

[@pedja2518]

As always, amazing video! Thnx!

[@HowtoPowerBI]

Thanks 🙏

[@mccmcc4612]

Very cool. Thank you for the clear instructions. Question...is there a way to link 2 field parameters? I have a line and clustered chart of Oil per month. X Axis is the Month, Column y-axis is Quantity with a field parameter of Unit of Measure (Barrels, Gallons or Metric Tons). Line y-axis is the Pump Rate. Pump Rate is also a field parameter by Barrels per Hour, Gallons per Hour or Metric Tons per Hour. Is there a way to link the 2 parameters? If the user selects the Quantity of Barrels, then the Load Rate will auto select Barrels per Hour?...or could I create a new measure to divide the Load Time by the selected parameter?

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

[@rodneydieguez52]

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.

[@HowtoPowerBI]

Thanks Rodney! Time to grow the skills/confidence and see where it takes you :) keeping fingers crossed for you my friend!

[@sadyaz64]

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

[@HowtoPowerBI]

Glad to hear that! thank you so much 😊

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

[@SolidSnake59]

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

[@HowtoPowerBI]

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

[@ronaldoshibuya4439]

Another awesome video, Bas. I have a question about your x-axis. How did you manage to get the year, quarter and month structured like that?

[@rasjel007]

I have the same question Bas! How did you do that?

[@Luggruff]

Just make a table with dates that spans the date range you need for your data (or download a pre-made calendar table that generates dates based on start and end date that you select yourself in query editor steps). Once you have a date table with a column of unique dates, create a relationship between the date column in that table, and the date column of your data. The date/calendar table will have a date hierarchy automatically. If not, it will automatically get one as soon as you drag the date column into the axis you want it in.

[@gopinathn9059]

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

[@HowtoPowerBI]

awesome!! 😎

[@TrassBI]

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

[@marjensendk]

Looks pretty useful. Is this also the feature you'd use for a financial statement, if you want the use to be able to switch between month or year to date, and also switch the comparison figures between last year or budget?

[@paulrockliffe2378]

Absolutely!

[@HowtoPowerBI]

think so 2😀

[@marjensendk]

Then i love it, thanks :)