The ONE THING that Fields Parameters Were Always Missing

In this video I show you how to unlock a totals option for fields parameters.

Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:19 Up and running with Fields Parameters
04:03 Adding Totals "See All" Option to Fields Parameters
06:52 Controlling multiple visualisations with Fields Parameters
08:20 Making it look better
12:00 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[tmaris]

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

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

[pavelhanus]

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

[wandawestbroek]

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

[bluebell]

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!

[davidpuddicombe]

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

[joelluis]

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

[mattstyles]

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?

[alexrosen]

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

[wilconagtzaam]

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

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

[nishantkumar]

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

[barttitulaerexcelbart]

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

[tofonofo]

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

[HachiAdachi]

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

[lmc]

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

[Vishek-yg]

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

[aryait]

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

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

[jillyapple]

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