Power BI Field Parameters - Why & how to use them?

[@info2satish]

Brilliant...just awesome feature now by powerbi...and so brilliantly explained by you sir. Namaskaram 🙏😀

[@chandoo_]

Namaste Satish... 😀🙏

[@vijayarjunwadkar]

Thank you Chandoo, It's really most useful and novel feature, but need to think and practice to put it for use. Of course your explanation and examples are spot on, as usual and will help us build upon it easily! 😊👍

[@chandoo_]

You are welcome Vijay.

[@Vhab14]

Thank you for explaining In a very simple, clear and fun way!

[@culpritdesign]

This is amazing! In the past we had to do this by duplicating data in power query.

[@chengwang411]

wow, i used to create a table and use a combination of switch/selectedvalue to get this. now it is much more simpler. great tip. kudos

[@pratikfutane8131]

Great session. The sound used for clicking the Field Parameters option in Preview feature at 1.53 is hilarious😄. Jokes apart, session is awesome. Thank you!

[@EXCELMANIA-kk5gg]

Great explanation, you make it easier sir. Thanks alot 🙏

[@tanvirszone8443]

Chandoo is a no.1 data analyst in my opinion, A great human being, a true kind hearted man who never looking just for money but for helping others by giving techniques . plz subscribe his channel. Respect chandoo, love from Bangladesh .

[@PawanKumarSG]

Hi chandoo, You explain each one of concept regarding data so well. My question is how do you make video so interactive and animated. Please reply Take care 🙏

[@chandoo_]

Thanks Pawan. I use Camtasia to create and edit my videos. As video editing is one of my passions, I try to learn new and effective ways to communicate ideas. I made a video about the behind scenes here. Feel free to watch it - kzbin.info/www/bejne/hmG6k2lnaq-JkNk

[@kerpal4442]

Succinct and clear demonstrations. Thank you!

[@shubhamsanas5242]

Hello, Thankyou for an eye opening Video...! Can u please make out one on how to create parameters as per Tableau in Power bi.

[@akashhanchatet-2842]

Your teachings + Your efforts are more awesome than the Awesome Chocolate Buisness (Dataset of yours ) 😂❤... Thank you sir, The content was really helpful 🙏🏻✨

[@rahulbaradkar]

You are awesome sir, nicely explained and video editing wahhhh....

[@boyanpallysaraswathi5625]

Thank you for explaining the field parameters

[@GeertDelmulle]

So, now we can use slicers/selectors, not just for filtering the visuals, we can also use them in the column headers (grouping/categories), in the row headers, and in the values sections of pivot-like visuals, and use all of this dynamically. Of course that is super useful to reduce the number of visuals we need to put on one page, provided we don’t want to see them at the same time. Somehow, in hindsight, this evolution seems a logical step and predictable. I wish I had predicted it myself. :-)

[@GeertDelmulle]

PS: I would call them FIELD SLICERS.

[@chandoo_]

Yes. It is one of those things that changes the way we think about visuals. Pretty soon, no one remembers the time when we didn't have this.

[@mouadmoulay6168]

Just brilliant ! and many thanks for your awesomely very insightful videos

[@teryn3723]

Thank you!

[@salehmuhammad6811]

Great Chandooo this very helpful and powerful feature of power BI which make easy to customised things.

[@chandoo_]

Glad you liked it

[@44.7b.kaharaditya6]

Great, I will utilise this in my upcoming projects

[@chandoo_]

Awesome to hear that Aditya. Do let me know how it goes.

[@NickJohns-q8c]

Thankyou sir. Your content is really amazing. keep making the videos

[@guilouback]

In this demo, can we combine the first case and the second one? Using the Measures Parameters for values and Column Parameter for axis? Thanks!

[@chandoo_]

Hmm.. good one. I think _we can_ but I haven't' thought about the DAX for that.

[@chandoo_]

Ok.. I had a play. This is simpler than it sounded. You just put "column selector" measure on X axis and "measure selector" on Y axis. Add both slicers and you have a 2 way field control.

[@guilouback]

@@chandoo_ neat! thanks agains!

[@ganpathji]

Very Good explanation Chandoo....loved that magic gal clipping 😃

[@samikshaKamble-r1u]

really an awsome feature.....Thank you soo muchhhhhh

[@equiwave80]

Thanks for this video. Your explanation of Field Parameters was easy to understand. I have only recently switched my career to data and I am working in Tableau. I have a small question regarding Field Parameters in Power BI. Can we relate this to the Parameters concept in Tableau? Or are they completely different. Ohh and you got yourself a new subscriber!!!

[@chandoo_]

Welcome the channel Deepak. I have not used Tableau in many years now. So I can't really compare. I suggest doing your own research.

[@cupidcutiedesigirl]

fantastic feature! thanks for explaining it so clearly!

[@chandoo_]

Glad it was helpful!

[@bradj229]

Very cool! Thanks for explaining and demoing.

[@SallyWanjiru-z5o]

I have been trying to use the parameters but they do not affect any visual I make how do I make it responsive

[@SandipanSarkar-c8v]

Finished watching

[@chrism9037]

Thanks Chandoo!

[@chandoo_]

You are welcome Chris 😀

[@vijaykumar-sv5ti]

can we add columns in parameters rather measures??

[@acceleratingthebeast]

is this dynamic filed parameter?

[@tomriddle8708]

Hi Chandoo, How can load multiple excel file with different attribute different columns to ms sql server using SSIS?

[@chandoo_]

I don't know. I haven't tried it. Nor I am too familiar with SSIS.

[@GracefulTalesPluto]

Chandoo garu, please post Qlik Sense tutorials too if you can please--

[@chandoo_]

Thanks PJ for the comments. I don't use Qlik. So unable to add anything for now.

[@yogeshindulkar320]

its really awsome you make my day

[@gauravsingh8274]

Awesome gajab sir

[@chandoo_]

Indeed.

[@arbazahmad7177]

Quite helpful... thanks for this.

[@JagadishHiremath-l8r]

sir, what is the difference in slicer and parameter?

[@SandeepKumar-tn9hb]

Hi Chandu, I have latest version but I’m not able to see field parameters. Can you help me to have it

[@taizoondean689]

Thank you sir 🙏🙏

[@chandoo_]

Most welcome

[@eswar418]

Any openings for freshers in power bi...

[@ArunVR-py3lv]

How can we select top N in field parameter if there is multiple rows?

[@granand]

Wow awesome feature.

[@chandoo_]

It is 😎😎😎

[@nikahafiz1]

can field parameter be used to filter further items within a selected column?

[@chandoo_]

Hmm.. don't think so. You can use a slicer on the fields. If you do find a way to do this, let me know.

[@travelkare]

Just Wow !

[@pgkannan]

Thank you

[@chandoo_]

😍😍😍

[@arvindr2101]

Super Sir, Thank you for your support

[@chandoo_]

Welcome 👍

[@rainbow433]

calculation group vs field parameters?

[@xabitoor3692]

Hello can you plz put the files you use in this video in this column. thanks

[@chandoo_]

Hmm.. the link is in the video description.

[@vijaykumar-px5yc]

Hi chandoo i need furure forcast in power BI with dax

[@jjenabh]

Brilliant

[@arbazahmad7177]

Awesome 👌 as Always....

[@chandoo_]

Thank you so much 😀

[@manojprabhakar7951]

good one!

[@chandoo_]

😎

[@SAXENA2904]

Thanks 4r share g.

[@chandoo_]

Most welcome

[@rakeshmahakud110]

Great 😃👍

[@hubaaltraining]

This is cool.

[@chandoo_]

IT IS!!!

[@mshparber]

But we could do it previously with disconnected tables… Or do I miss something…

[@chandoo_]

We could, but this makes the process simpler.

[@mdwasitalinayyar]

How to achieve this in Excel?

[@chandoo_]

You can use this approach - kzbin.info/www/bejne/gmS6d4Fml6ypbqs

[@carpediemwithLesli]

Interesting!!

[@chandoo_]

😀

[@cupidcutiedesigirl]

hey mate do you have a power BI course on udemy ?

[@chandoo_]

I don't have anything on udemy. But I do have a course on Power BI here - chandoo.org/wp/power-bi-play-date/

[@cupidcutiedesigirl]

@@chandoo_ Cheers. I will check this out.

[@arimorrison7816]

epic!

[@SandipanSarkar-c8v]

Finished watching