Using Power BI Field Parameters to add Measure Slicers to a Report

In this video, we will explore how to use Power BI Field Parameters to add Measure Slicers to a Report. Measure Slicers are extremely useful in Power BI as they help in viewing and analyzing data more efficiently. With the help of Field Parameters, we can easily create Measure Slicers and customize them to meet our needs. This tutorial provides a step-by-step guide on how to create Measure Slicers using Power BI Field Parameters.

Introduction to Dynamic Measure Selection 0:00
Challenges with Multiple Measures 0:30
Slicer Implementation with Field Parameters 4:10
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks

[alexrosen]

A simple and very effective way of showing an example of how to use field parameters. Thanks

[pthapa]

Yes, it definitely would help instead of having multiple visuals, all in one. Thank you for awesome video.

[jjdlaa]

Thank you for sharing. I always enjoy Mitchell's videos!

[assaparan]

Thank you very for this well made tutorial video

[janade]

This is perfect video and perfect features. I am glad they included it. Just not able to use with the Analysis Services Live Connection and that is also very needed. Hope it will come soon also.

[seth]

Field parameters aren’t limited to just measures, you can incorporate dimensions as well. If you put the parameter in another slicer and set it to show values you can also create a dynamic slicer that lets users pick what they want to filter on too. Additional, by adding columns to your field parameters you can link them in the modeling view and then you can use those new columns as filters to dynamically alter the available field parameter options across multiple visuals providing totally different pieces of analytical information!

[furkansimsek]

Thank you so much for sharing❤ You guys are doing an amazing work.

[freddylara]

Thank you, Michell! You’re the best! Your message is crystal clear, which makes difficult concepts easy to understand. Can you make a video about the new feature in Power BI: Calculation Groups?
Thank you again for putting the time to teach us DAX through your videos.

[j.bagalay]

So cool!! This is literally very helpful for my future dashboards!❤

[softwine]

Thank you very much Michel for this easy way.
I believe that there is another way via using Calculation Groups in DAX Studio. But it is a little bit tricky.

[cartersa]

Which version of Power BI are you using here? I’m on PBI Desktop 2.121.1642.0 (September 2023) and I don’t have this capability from what I can see, only a What-If parameter.

[Wzxxx]

Is there a method to filter a parameter by result of other measure. I can't figure out how to do it. So a measure "result1" reasult i.e 1, 2 or 3. I want to Parameter choose depends on this result so if it 1 -< choose first row from parameter etc. Without using any slicer. I

[macbelwoldie]

Is the parameter a table? if so, is there a relationship between the parameter and your tables in the datamodel?....Somehow its not working for me

[jiridvorak]

It doesn't work with live connect.