Mastering field parameters in Power BI | A practical and common use case

Ready for some brain training? In this tutorial we will build a common use case for field parameters and push its capabilities to the max to make them do what we need :)

Chapters:
00:00 Intro
00:55 Field parameter for multiple visuals
02:58 Custom columns for field parameters
03:44 Custom slicers for field parameters
04:18 Set up one Field parameters for multiple visual/measures
05:30 Conditional formatting for field parameters
09:13 Multiple field parameters for complex visuals
10:24 One slicer for multiple field parameters
11:32 Test the solution & Wrap up

End

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10

Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[JasonBeck-gb]

This is so good; saves having to create extra dim tables. THANK YOU!

[ThreadRider]

Thanks Again Ruth! I really appreciate all you do for the Power BI community.

[SarahTran]

That's amazing. Your are a life saver.

[arbazahmad]

I was searching that how to do conditional formatting with field parameter. Then I find this video which is quite helpful.
Thank you so much for this 🙂.

[olgaitskova]

Thank you so much Ruth, you saved my day!

[antonycatella]

Thanks Ruth. I have been trying to work out how to do the conditional formatting based on a column in the original dimension tables and this video gave me the final puzzle piece

[jafujafu]

Thanks for posting this video. Your work is always appreciated in sharing your knowledge. Learning a lot from your videos and always looking forward to the next.

[mounica]

Thank you so much! I was struggling with the composite key error and your video solved my problem.

[nightgoths]

Hello! I just found your channel and it's incredible how well your explanation is and how simple you made it to solve these problems. Thank you for sharing your knowledge with us <3.

[JohnOttoKnoke]

Wow! What a great video, Ruth. Saludos

[pmenown]

Thanks Ruth, i couldn't find any other information available about how you implement Field parameters into DAX formula's only using them in slicers. I kept getting the same Composite key error you got at 6:36. This is going to reduce so many DAX formula's i've got for one report. Thank you very much!

[theexperienceof...]

You saved me with this one! Thank you!!!

[joanneosborne]

They're almost as cool as you, Ruth. I love all your videos and this one doesn't disappoint. Thank you 😊

[noahhadro]

Love your videos. You can also add columns by updating the dax. For Example: ("Recruiter", Recruiter]), 36, adds a fourth column. You may already know this.

[juniorholder]

Creative solution and extremely helpful!!

[slasher]

That's really cool, you saved my day madam.

[mabenba]

Nowadays everyone is talking about field parameters. Thanks for sharing this clarifying tutorial!

[lukaszjaniszewski]

Thanks for those tips. I am waiting for parameter that also can change type of visual, not only measure

[kisshor]

Hello mam, hi dere, kisshor here frm india mumbai
I loved to watch your videos its very helpful i m enjoying and wiating to learn new things.

Mam is that slicer card and fied parameter both are same??

What is diff between them..
Pls ans.

[cristinaperez]

Wow, this video is a big help. THANKS!!!
However, it might be possible to have at the same time a single matrix that displays all the metrics chosen from the parameters, but next displays a chart that show only one parameter is chosen(if it is more than one parameter brings message "Single selection required").

I try something like this...But I see the parameter measure only can be limit in the Visualization>Visual>General >multiple selection.

test.show_one_value=
VAR Threshold_ = 2
VAR Current_ = COUNT('Measures Slicer'[Measures Slicer])
VAR logic_= Current_ < Threshold_
VAR sss = SELECTEDVALUE ('Measures Slicer'[Measures Slicer], ERROR ( "Single selection required" ))

RETURN
if(logic_, sss, ERROR ( "Single selection required" ))