Using Power BI Field Parameters to add Measure Slicers to a Report
Vložit
- čas přidán 5. 08. 2024
- 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
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks
A simple and very effective way of showing an example of how to use field parameters. Thanks
Thank you for sharing. I always enjoy Mitchell's videos!
Yes, it definitely would help instead of having multiple visuals, all in one. Thank you for awesome video.
Great video Mitchell. Thanks!
Thank you so much for sharing❤ You guys are doing an amazing work.
Absolutely incredible.
Thank you very for this well made tutorial video
Awesome! Thank you, Michell
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.
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!
Great point!
Hello. That sounds great! Di you have an example?
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.
So cool!! This is literally very helpful for my future dashboards!❤
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.
Excellent!!!
Life saver!
Awesome
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.
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.
It is a preview feature. Go to Files - Options - Preview and turn on field parameters
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
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
This works in Power BI RS?
It doesn't work with live connect.