The ONE THING that Fields Parameters Were Always Missing

[@tmaris]

I think there is a problem with the framerate of the video. Besides that, congratulations man!

[@naylord5]

I reload the video a few times because of this xD

[@Daithi354]

Well its 17 hours later and its still borked.

[@android01978]

Sadly still a problem for me. Great content though.

[@popk814]

ya'll just cant appreciate some good motion pictures

[@dcbelbiteam]

Won't be long before you reach 1 million imo. You are by far the best channel for everything Power BI related. Your approach to teaching and explaining complex Power BI methods really helped me a lot!

[@HowtoPowerBI]

Wow thanks super happy to hear!

[@mirrrvelll5164]

I can sign it too! =) I got my top 10 KZbinrs (channels) and You are Nr1 in Power BI =)

[@alicedwonderland7733]

Thank you, Bas!

[@HowtoPowerBI]

ahh nice to see you here! thanks a lot for the support

[@pavelhanus8819]

Hi Bas, first congratulation! Second I would like to share my favorite trick with field parameter - to be able switch between multiple calculations using combination of single select slicers. You can add more columns to field parameter to be able to do it. An example: Calculation_Parameter = { -- volume ("Volume EU]", NAMEOF([Volume EU]), 0, "Volume", "Europe"), ("Volume USA]", NAMEOF([Volume USA]), 1, "Volume", "America"), ("Volume China]", NAMEOF([Volume China]), 2, "Volume", "Asia"), -- Value ("Value EUR", NAMEOF([Value EUR]), 3, "Value", "Europe"), ("Value USD", NAMEOF([Value USD]), 4, "Value", "America"), ("Value CNY", NAMEOF([Value CNY]), 5, "Value", "Asia"), } Thank you for your amazing contend. Pavel

[@wandawestbroek7960]

Gefeliciteerd met alle veranderingen! Fijn dat je weer terug bent, altijd reuze leerzaam de video's die je plaatst. Dankjewel ook weer voor deze.

[@bluebell459]

Congrats on the house, baby, and subscribers! Glad to hear that 2023 is treating you well so far and it's wonderful to see you back on YT!

[@nishantkumar9570]

Glad to have you back. Congratulations for every blessings you mentioned.🎉

[@lmc1969]

Congratulations Bass, for the baby and the 100k 😊. Your videos are amazing, thank you very much for sharing your knowledge ❤

[@HowtoPowerBI]

Thanks a million!

[@barttitulaerexcelbart9400]

Thanks Bas! Congratulations with your baby !! Looking forward to see you again....

[@HachiAdachi]

🎉🎉 Congratulations, Bas! And so good to see you back in the KZbin space! ☺☺

[@alexrosen8762]

Congratulations on your new arrival! And moving to a new place Welcome back and thanks for a great and useful tutorial!

[@HowtoPowerBI]

Yay! Thank you Alex! Glad to see you again here too :)

[@jahmed525]

This is super helpful. Much appreciated.

[@juliom6260]

Congrats. You deserve it. Head to 1M

[@joelluis4938]

I've been watching videos about field parameters in tables but this option for charts is amazing . Those parameters are powerful .. 🤯

[@kkskhin7208]

Congratulations 🎉🎉🎉🎉🎉. So happy for you. More achievement to come!!!!!! Thank you so much for youtube videos.

[@HowtoPowerBI]

Thank you, I really appreciate it!

[@psz34]

Congratulations!!! And THANK YOU!!!!!!!!

[@tofonofo4606]

Congrats and Welcome back Bas! Passed my PL-300 today. Thank you for the fun and engaging videos. o7

[@HowtoPowerBI]

congratulations :) and thanks!

[@davidpuddicombe7946]

Is there a way to get Field Parameters in Power BI Report Server? Thanks for another great video, very useful content!

[@wilconagtzaam587]

Awesome video Bas. This trick was also part of the Dashboard Design Training, which I can recommend to everybody!!!

[@HowtoPowerBI]

:):) thanks Wilco, glad you enjoyed it!!!

[@amaturescientist]

Second the recommendation!

[@samama1975]

Congratulations man. Great news indeed!

[@Robay146]

Congrats on your acheivements Bas! 👏🏽👏🏽👏🏽

[@HowtoPowerBI]

Thank you!!

[@mcnater]

Welcome back and congrats on the house and kiddo! Nice little trick for sure...looking forward to more vids this year! Have you tried out the new object formatting style? Yikes that's going to take awhile to get used to!

[@HowtoPowerBI]

thanks! yeah definitely more videos in making...yes, just playing around with it, weird at first but slowly getting a hold of it.

[@hannahiara]

Thank you soooo much! Love your work!

[@HowtoPowerBI]

Glad you enjoy it!

[@josefedericopresno6668]

Great to see You again, Bas. Thanks a lot

[@HowtoPowerBI]

:) happy to see you here too!

[@BestICan]

Congratulations on the new baby!

[@HowtoPowerBI]

Thank you so much 😀

[@josephabuo6027]

Wow! Congratulations for the new house and beautiful baby Boss.

[@juanignacioXI]

Baaaaas glad to see you again!, I was missing your content. A big hug master!

[@HowtoPowerBI]

:):) thanks for the welcome! Happy to be here too

[@juanignacioXI]

@@HowtoPowerBI Happy to watch ur videos, can u please share your color theme xD?

[@unnikrishnansanthosh]

back with a bang BAZ, thank you for sharing

[@meltem4267]

I love the idea and will apply to my reports😊

[@mezianeamrane2558]

Congrats for the baby ❤

[@HowtoPowerBI]

Thank you :)

[@joaoluismartins]

Great tip!! By the way, not sure if this was always there, but you dont need anymore a column on your model. You can just use "None" instead of NAMEOF(Column). Cheers!

[@mattstyles9714]

A more pressing feature that Field Parameters are missing is naming the fields based on a measure...dynamic naming. Any ideas on how to make that work?

[@kiran521]

This is next level❤

[@paulgallagher2987]

Great tip as always! Thanks Bas and huge congratulations on becoming a Dad! :)

[@chekrooon5179]

I missed you! Congrats on the house, baby and training, looking forward to what's to come.

[@HowtoPowerBI]

thanks! definitely more (videos) to come! ;)

[@sekarchandu1869]

That's a great work around currently u r doing to share complex things into more understand hope we will see u in great position in future Thank you 👍

[@HowtoPowerBI]

Thanks a lot for your kind words!

[@FlorinLeban]

great tip. very useful

[@HowtoPowerBI]

Glad you think so!

[@robinback6092]

Congratulations 🎈Bas!

[@AessamL]

Congrats on Everything!

[@HowtoPowerBI]

Thank you ;):)

[@PeterKontogeorgis]

Congratulations on the birth of your child Bas!

[@HowtoPowerBI]

Thank you so much 😀

[@RodrigoSantos-mz4vs]

Amazing 👏👏👏👏👏👏👏👏👏👏👏👏

[@HowtoPowerBI]

Thanks a lot 😊

[@Vishek-y8g]

can we use 1 numeric range parameter and 1 field parameter on the same visual in power bi ? If yes, please provide the same video link. Thanks

[@arya4it]

Hi, Thanks for the videos. I have a quick question for field parameters How to add field parameters in matrix so the names will appear in first column and after that the values for different months Thanks

[@malungosebastiao]

Hello Bus, can you teach us how to create a custom visuals in Charticulator like radio chart. Thanks

[@321kh]

Very helpful, thank you! Ideally you would avoid 'Totals' appearing twice in the legend when Totals is selected...

[@sunnyr7396]

Thank you for your extremely helpful videos and for sharing your knowledge with us. Btw. Concratulations for being a daddy now! Enjoy every day !!! This will be the best time of your life.

[@HowtoPowerBI]

Thank you so much for the kind words! yes... my second baby ;) so totally enjoying it, now double portion haha :)

[@Magesh01]

I have a problem with field parameter. Every time I toggle between parameters the sorting orders are changed in the visual so we have to make a custom sort order columns. But is that recommended to have extra columns since it is only needed for custom sorting?? BTW i love your videos i'm learning Power BI from home with the help of your videos

[@terpstry]

Congratulations Bas!

[@HowtoPowerBI]

Thank you :)

[@vishekmangla]

Can we use 1 numeric range parameter and 1 field parameter on same visual in power bi ? If yes, Please provide me the link for that video. Thanks

[@jillyapple1]

This is great, thank you. But what if, when selecting Time of Day, you only wanted Day and Prime, but not Night? But for Total, you want the total of all 3? (I'm working on a thing where I want to toggle between a pre-selected subset of stores, and all stores).

[@alexandrewartel8771]

Hi Bas, thaaanks a million for the videos : both the content, and the so nice energy in it, and that we get out of it. not sure my english is correct, but my intention is :) my post is as well interested... would you know how to show top N of one of the dimension of a field parameter ? i did it for one of the dimensions, but i had to add a whole column in the fact_table, which takes space. do you think of a less space consuming trick ? hi as well to the Bas community ! thanks again for the great content, and for sharing your knowledge ! cheers. Alexandre

[@alexandrewartel8771]

I found it ! let me know if interested.

[@pawelostr7963]

@@alexandrewartel8771 It would be fantastic if you could explain what is the solution :)

[@KrishnaD-m3q]

Hello Bas, how a seperate metrics field is created?

[@narendersingh2669]

Hello Bas Congratulations Thanks for making this amazing video. I have one use case where I have worked one step beyond this. Like in the legend we want the products but we want to show only top5 products with parameter selection. I will show some blank values. I have created this with the help of parameters , few topn measures and a switch statement. Please let me know if you need more detail on this.

[@23021982able]

Great. How to plot Polynomial trend line in power bi.

[@florianboissiere6211]

Great to see you back Bas! Congrats on the new kid! Don't know how you juggle kid + youtube + life lol

[@HowtoPowerBI]

Thanks a lot happy to see you here! one day at a time strategy… 🤪

[@narendrababu2287]

Congratulations🎉🎉

[@HowtoPowerBI]

Thanks 🙏:)

[@piotrkuc8936]

Hi, Could you advise if it's possible to have drillthrought once "Total" is selected? It's working well for other options in parameters. Congratulations on your 2023 achievements 🎉

[@lisadbrooks]

Congrats!

[@kuuuyajim]

Wonderful! I don't have a use case right now though since our clients prefer matrix tables. 😂

[@thiagomatano4099]

Hello, my name is Thiago and I'm from Brazil, I would like to know if you have a video explaining how to make a rounded bar graph? Congratulations for the work, I really like your videos!

[@visheshsaxena2109]

Great trick. You could have used visual shadow option instead of white background box and visual title instead of additional text box. Better to have minimum visuals.

[@HowtoPowerBI]

Thx ! Padding didnt exist when this was recorded

[@gilad3339]

the video is not worling well.. could you please fix it? thanks :)

[@HowtoPowerBI]

yeah... cant fix it anymore :( sorry

[@SSM_33]

i love the new background

[@HowtoPowerBI]

Super glad to hear this!!!

[@waynekranz7813]

Congrats

[@AnilKumar-vi8oe]

Video frequency very low these days, keep teaching your skills

[@HowtoPowerBI]

That’s about to change no worries

[@AnilKumar-vi8oe]

@@HowtoPowerBI Great to hear

[@mogarrett3045]

Bas is awesome

[@AndyDevineUK]

Welcome back!!

[@HowtoPowerBI]

Thanks!!

[@MrSparkefrostie]

If onpy field paramaters could switch field parameters, ie pick between manahent, metrics, etc, when picking a manager you get another slicer with all the management layers and if you pick metrics the same slicer will switch to the different metrics

[@MrSparkefrostie]

@@pjennings72 will check it out thank you

[@mohdmuzammil3059]

Congratulations

[@HowtoPowerBI]

Thanks!

[@luciaizquierdo1085]

Perfect videos and congrats on your fatherhood. I don't get it. Perfect without parameters. But with parameters I am just given the option count. So the numeric values do not show. Does someone know why?

[@luciaizquierdo1085]

For more info the column is a Format : decimal number but when I put it in a parameter turns into Format: Text so does just counts

[@luciaizquierdo1085]

And...when I try to change it in data type then I get an error and will not work

[@Qweertyyuiiop]

Much better to use a blank measure. That way you dont increase the size of your model ;)

[@pawelostr7963]

Would you be so kind to write how to do it exactly and provide a DAX code, please?

[@biggc181]

How to Bi turned in to How to PowerPoint for this video lol

[@datactive859]

Bro how I missed you

[@HowtoPowerBI]

guess it's a good thing ;) super happy to be back!

[@datactive859]

@@HowtoPowerBI congrats to your new place and baby. So glad to have your new brilliant ideas with us

[@alivirk3803]

there is a problem in video

[@HowtoPowerBI]

Yes next time better ;)

[@kian69topgun1]

is it just me or does the video lag?

[@HowtoPowerBI]

Yes.. sorry!

[@maniac123ful]

Im using parameters to calculate Data For this month, last month, last year. Question: How can i have the parameters name to dynamically change every month, depending on the slicer i click?

[@emilyamalkin4367]

👍🏻