Using Power BI Field Parameters to add Measure Slicers to a Report
Рет қаралды 15,181
Күн бұрын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.
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
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:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZfaq: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks
@alexrosen8762 5 ай бұрын
A simple and very effective way of showing an example of how to use field parameters. Thanks
@jjdlaa804 7 ай бұрын
Thank you for sharing. I always enjoy Mitchell's videos!
@mozz_7061 6 ай бұрын
Absolutely incredible.
@pthapa55 7 ай бұрын
Yes, it definitely would help instead of having multiple visuals, all in one. Thank you for awesome video.
@bradj229 5 ай бұрын
Great video Mitchell. Thanks!
@seth3681 7 ай бұрын
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!
@PragmaticWorks 7 ай бұрын
Great point!
@desenterrados2022 7 ай бұрын
Hello. That sounds great! Di you have an example?
@furkansimsek33 7 ай бұрын
Thank you so much for sharing❤ You guys are doing an amazing work.
@assaparan2214 4 ай бұрын
Thank you very for this well made tutorial video
@janade3644 5 ай бұрын
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.
@tacijjola 7 ай бұрын
Awesome! Thank you, Michell
@ugochukwunwasuruba1356 Ай бұрын
Awesome
@j.bagalay1623 3 ай бұрын
So cool!! This is literally very helpful for my future dashboards!❤
@freddylara6383 7 ай бұрын
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.
@softwine91 7 ай бұрын
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.
@123arthurcavalcanti 2 ай бұрын
Excellent!!!
@WendyLiu-hk6lr 4 ай бұрын
Life saver!
@agelee89 4 күн бұрын
i have a problem to combine two parameters and keeping multiple choice for measures working. In my graph I have also parameter for switching between Quarter/Monty/Week/Day on X axis. And then multiple choice for measures parameter doesn't work.
@cartersa8758 7 ай бұрын
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.
@antonycatella5901 5 ай бұрын
It is a preview feature. Go to Files - Options - Preview and turn on field parameters
@Manu-li1rw 7 ай бұрын
This works in Power BI RS?
@macbelwoldie6201 4 ай бұрын
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
@Wzxxx 5 ай бұрын
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
@jiridvorak1262 3 ай бұрын
It doesn't work with live connect.
Fernan
Рет қаралды 15 М.
How to Power BI
Рет қаралды 133 М.