Mastering field parameters in Power BI | A practical and common use case
HTML-код
- Опубликовано: 1 авг 2024
- 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
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
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:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
This is so good; saves having to create extra dim tables. THANK YOU!
Thanks Again Ruth! I really appreciate all you do for the Power BI community.
Thanks 😊!
Thank you so much Ruth, you saved my day!
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
That's amazing. Your are a life saver.
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.
Thanks!
You saved me with this one! Thank you!!!
So cool and easy to understand!
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
Wonderful:)
Creative solution and extremely helpful!!
Thanks!
Thanks Ruth! Very useful
Un placer :)
They're almost as cool as you, Ruth. I love all your videos and this one doesn't disappoint. Thank you 😊
Thank you Joanne ❤️!
Wow! What a great video, Ruth. Saludos
Muchas gracias y saludos!
Great, video!!! Tks!!!
Thank you so much! I was struggling with the composite key error and your video solved my problem.
Fab to hear!
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 🙂.
My pleasure !
That's really cool, you saved my day madam.
Never long videos, keep going
Nice trick to conditional format!
Thanks! :)
Love your videos. You can also add columns by updating the dax. For Example: ("Recruiter", NAMEOF(DIM_Primary_Recruiter[Primary Recruiter]), 36, "Req")...........This adds a fourth column. You may already know this.
Didn’t know, thanks!!
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!
👏👏
Thanks for those tips. I am waiting for parameter that also can change type of visual, not only measure
I think someone did that already but can’t remember who :(
Any ideas on how to retain the filtering across visualizations? When I implement this version with visualization that have different measures (let's say $ Sales and % Change vs. PY) and click on one of those measures, it filters other visual. It is the same in your PBI file as well.
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.
Hola Ruth,
Thanks for your great explanation on advanced field parameters
Still, I have an issue when I try to apply them to a small multiples chart showing the evolution of top performers countries by mesure, so I need the top on top.
The report is a line chart with time in the x-axis, the measure in y-axes and country as small multiple category, every time slice it defaults to sort by country, I can only customize one case (it would be ideal it it could remember all!)
Alguna pistalla?
\carlos alvarez-cascos
very clear
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" ))
Thanks for the great video, Ruth.
Is this method of using parameters better than using bookmarks to hide/show the visuals with different measures?
Yes, less things to load and easier to maintain imo
but you cannot control data sorting (users have to sort manually) which is annoying; with bookmarks you can save sorting on a chart
Thanks and great! , where can i download the pbix file ?
EDIT: I found it, I just needed to enable the feature in the Options!
Hi! As usual, thanks for all the quality content 😊 this channel really helped me professionally! Now, I have the June 22 version of Power BI and... somehow I cannot find the parameter dropdown as shown here (in the Modelling ribbon I only have the "What-if" parameter, which works quite differently as you can't really choose any field). Am I missing something? Was it moved or removed after May?
Great!
Hello, Thanks for sharing, It's very interesting.
I have a business need where I have multiples field parameters slicers (Activity, Product, Client, Date..).
In the table I need to show only the columns which are selected in the slicer and not all the columns by default. For example if I have no column selected in the product slicer, the table doesn't have to show the product Columns.
Do you have any idea about how I can achieve that?
Thank you
great video! do you know how to maintain sorting on your parameter in a matrix when switching selections? For example I have a parameter switching between quantity purchased and purchase amount and want to sort largest to smallest. But when I change the parameter the sorting goes away
Maybe it is not possible yet?
exactly, why no one mentions this? users will have to sort each time they change a parameter...
In the other visuals it is fine, maybe it is just the matrix? Haven’t tried field parameters there yet
Hi, How to select values from, ie "VALUES(field parameter table[column])" for dynamic selection of columns from different table ?
HI MAM COULD YOU PLEASE MAKE A VIDEO ON Market Basket Analysis ....
can we do the same without field parameters?
if yes, can you share the link or article on it
Hi i always watch your videos and its easy to understand i want to learn more about parameters lets say i want to set a parameter for my one country and the basis of which i want to see sales amount for that particular country but the output which i am getting its showing me a blank table for other values. how to set parameters for country region and group
I would like to see if you can used field parameters to show row data? Goal is to show and hide weekly breakdown for all columns applied, but I have 5 rows that need to stay visible.
Hi,
We configured a stacked bar/column chart with dynamic x axis and legend with the help field parameters.
Though in power bi service I am unable to export the data properly.only summarized export is available(with out any dimension).
Could you please help.
Hi Ruth,
Thanks for the video
Just one question. I´m wondering if it could be possible to use field parameters for selecting the field in a slicer instead of in a table, matrix, gfx
The idea, just as an example, is to have a field parameter which values could be : years / quarters / months so if you select years, on the second slicer you will have the different years for your data but, if you select months, the second slicer will show the different months .
It is, somehow, "to slice the field to be used in a second slicer". Any ideas on how to implement something similar to this, either with field parameteres or somehow else
Many thanks in advance
Hi Nacho,
I show it in this video:
m.ruclips.net/video/5vLBnrPyPgc/видео.html
Hi@@CurbalEN and thanks for the quick answer. I´ve already watch that great video and, in fact, that´s where my idea came from but, as far as I can undestand, it is a different case.
If I correctly understood, in your video you have a limited number of fields that you can divide in two groups and that´s what first slicer does
In my case I do not know how many values are on each field. For example, if I have this year data up to today, I have six different values on the months field, but next month, there will be seven ..
What is driving me crazy is that it works (I see months values 1-6) if I visualize the field using a table, but it I use a slicer, I see the option "MONTHS" (the one selected on the first slicer) instead of the months values
I´m sure there´s some critical concepts I´m not correctly understanding
It sure I understand your requirement correctly, but if you connect the slicers on they are in the same table, won’t they filter each other ?
Hi @@CurbalEN , yes they do.
The problem is that, in the example in your video, the slicers do not show field values but field "names" while what I am looking for is to show field values on the second slicer.
As a workaround what I am presently doing (but not satisfy) is to use a treemap visual with a measure=1 value and "slice" by selecting on that visual.
Thanks
I am not really understanding the use case, so my answers are not very useful, sorry!
awesome @curbal
Do you have a video on how to use Field Parameters inside DAX... Specifically with DAX functions like "ALLSELECTED" and other dimension type functions.
Nowadays everyone is talking about field parameters. Thanks for sharing this clarifying tutorial!
You welcome , they are neat if used properly :)
Hi Curbal,
My stakeholders want the x-axis to dynamically show Last 5 months, Last 5 Qtrs, Last 5 Years etc.
I created new columns for each in the date table
e.g. Last 5 Months column has Month names of latest 5 Months and rest values as BLANKS..
I used the new field parameter to change the x-axis ..
The only problem is how to hide the BLANKS..
Please help..
Can you show us how to pass the selected value of a slicer to the parameter of a stored procedure. I want the stored procedure to fetch only the data which the user selects in the slicer.
I don’t know if that is possible
What is the version that has this options? I'm running a version of January 2022 and I can't find it.
I think it was made available in May version
Hi Ruth,
I am an avid watcher of your videos.
You made a video some time ago that quoted an author about the importance of getting insights from the data. I think it was mentioned that we live in a data age and not an information age yet. We are constantly bombarded with data but we don't know what to do with it. Can you please link that video for me? I don't remember exactly which one of your videos had this quote. Thank you!
Sure,
I think it is this one:
Will datamarts become the online version of Power BI Desktop?
ruclips.net/video/YiNhSm4yUvg/видео.html
@@CurbalEN Thank you!
Can we create a dropdown menu from these field parameters?
Like a slicer?
@@CurbalEN yes, but in a dropdown menu
Yes, just change the slicer type :)
@@CurbalEN could there be a reason why this is not working?
Maybe the theme ? Change it to see if it works better
Do you know maybe when it will be general ? 😭😭😭😭
Nope :(
Hi Ruth! I just started my Power BI path and like to watch your video, so easy to understand. I have a question, it's just a coincidence: yesterday I watched this yours video about change measures using slicer (posted 3 years ago) ruclips.net/video/gYbGNeYD4OY/видео.html ) , is feature like 'Field parameters' replacing those video?
Sorry to say but this seems more like a thinking-out-loud video than a well-thought through and polished one.
It might seem that way, but there are many many hours spent on this video. Care to develop why you feel that way?
Ruth as well as many other contributers to the community give up a lot of their time to produce content / videos for the community. Do you have a RUclips channel to demonstrate what a 'well-thought through and polished video' is?