No video

Mastering field parameters in Power BI | A practical and common use case

  Рет қаралды 35,972

Curbal

Curbal

Күн бұрын

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

Пікірлер: 86
@JasonBeck-g1b
@JasonBeck-g1b Күн бұрын
This is so good; saves having to create extra dim tables. THANK YOU!
@SarahTran1240
@SarahTran1240 Ай бұрын
That's amazing. Your are a life saver.
@nightgoths
@nightgoths 2 жыл бұрын
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
@ThreadRider
@ThreadRider Жыл бұрын
Thanks Again Ruth! I really appreciate all you do for the Power BI community.
@CurbalEN
@CurbalEN Жыл бұрын
Thanks 😊!
@jafujafu7611
@jafujafu7611 2 жыл бұрын
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.
@CurbalEN
@CurbalEN 2 жыл бұрын
Thanks!
@olgaitskova8542
@olgaitskova8542 6 ай бұрын
Thank you so much Ruth, you saved my day!
@antonycatella5901
@antonycatella5901 2 жыл бұрын
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
@CurbalEN
@CurbalEN 2 жыл бұрын
Wonderful:)
@theexperienceof...5357
@theexperienceof...5357 2 жыл бұрын
You saved me with this one! Thank you!!!
@user-vh1ez3qo1m
@user-vh1ez3qo1m 9 ай бұрын
So cool and easy to understand!
@mounica80
@mounica80 2 жыл бұрын
Thank you so much! I was struggling with the composite key error and your video solved my problem.
@CurbalEN
@CurbalEN 2 жыл бұрын
Fab to hear!
@joanneosborne2428
@joanneosborne2428 2 жыл бұрын
They're almost as cool as you, Ruth. I love all your videos and this one doesn't disappoint. Thank you 😊
@CurbalEN
@CurbalEN 2 жыл бұрын
Thank you Joanne ❤️!
@arbazahmad7177
@arbazahmad7177 Жыл бұрын
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 🙂.
@CurbalEN
@CurbalEN Жыл бұрын
My pleasure !
@juniorholder1230
@juniorholder1230 2 жыл бұрын
Creative solution and extremely helpful!!
@CurbalEN
@CurbalEN 2 жыл бұрын
Thanks!
@JohnOttoKnoke
@JohnOttoKnoke 2 жыл бұрын
Wow! What a great video, Ruth. Saludos
@CurbalEN
@CurbalEN 2 жыл бұрын
Muchas gracias y saludos!
@aleksvpYT
@aleksvpYT Жыл бұрын
Great, video!!! Tks!!!
@cesarramos3569
@cesarramos3569 2 жыл бұрын
Thanks Ruth! Very useful
@CurbalEN
@CurbalEN 2 жыл бұрын
Un placer :)
@pmenown
@pmenown Жыл бұрын
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!
@CurbalEN
@CurbalEN Жыл бұрын
👏👏
@noahhadro8213
@noahhadro8213 2 жыл бұрын
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.
@CurbalEN
@CurbalEN 2 жыл бұрын
Didn’t know, thanks!!
@slasher4328
@slasher4328 Жыл бұрын
That's really cool, you saved my day madam.
@lukaszjaniszewski2094
@lukaszjaniszewski2094 2 жыл бұрын
Thanks for those tips. I am waiting for parameter that also can change type of visual, not only measure
@CurbalEN
@CurbalEN 2 жыл бұрын
I think someone did that already but can’t remember who :(
@cathrerinezetadrones3169
@cathrerinezetadrones3169 11 ай бұрын
Never long videos, keep going
@skalsolutions
@skalsolutions 2 жыл бұрын
Nice trick to conditional format!
@CurbalEN
@CurbalEN 2 жыл бұрын
Thanks! :)
@trentbrewer3336
@trentbrewer3336 Жыл бұрын
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.
@cristinaperez3449
@cristinaperez3449 2 жыл бұрын
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" ))
@carlosalvarez-cascos5225
@carlosalvarez-cascos5225 Жыл бұрын
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
@kisshor1000
@kisshor1000 Жыл бұрын
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.
@pedroaoc
@pedroaoc 2 жыл бұрын
Thanks for the great video, Ruth. Is this method of using parameters better than using bookmarks to hide/show the visuals with different measures?
@CurbalEN
@CurbalEN 2 жыл бұрын
Yes, less things to load and easier to maintain imo
@heniekheniek1781
@heniekheniek1781 2 жыл бұрын
but you cannot control data sorting (users have to sort manually) which is annoying; with bookmarks you can save sorting on a chart
@digdin12345
@digdin12345 2 жыл бұрын
Thanks and great! , where can i download the pbix file ?
@iseydelmar
@iseydelmar 2 жыл бұрын
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?
@CurbalEN
@CurbalEN 2 жыл бұрын
Great!
@marouaneabil4165
@marouaneabil4165 2 жыл бұрын
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
@lso4jw251
@lso4jw251 Жыл бұрын
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.
@kajalsharma5889
@kajalsharma5889 7 ай бұрын
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
@Truth-N-Lies
@Truth-N-Lies Жыл бұрын
Hi, How to select values from, ie "VALUES(field parameter table[column])" for dynamic selection of columns from different table ?
@connerkoski2183
@connerkoski2183 2 жыл бұрын
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
@CurbalEN
@CurbalEN 2 жыл бұрын
Maybe it is not possible yet?
@heniekheniek1781
@heniekheniek1781 2 жыл бұрын
exactly, why no one mentions this? users will have to sort each time they change a parameter...
@CurbalEN
@CurbalEN 2 жыл бұрын
In the other visuals it is fine, maybe it is just the matrix? Haven’t tried field parameters there yet
@vaangovaangopakkurathukuva5916
@vaangovaangopakkurathukuva5916 2 жыл бұрын
can we do the same without field parameters? if yes, can you share the link or article on it
@angshukdutta9750
@angshukdutta9750 2 жыл бұрын
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.
@DavidPesante
@DavidPesante 2 жыл бұрын
Do you have a video on how to use Field Parameters inside DAX... Specifically with DAX functions like "ALLSELECTED" and other dimension type functions.
@gagansingh3481
@gagansingh3481 Жыл бұрын
HI MAM COULD YOU PLEASE MAKE A VIDEO ON Market Basket Analysis ....
@nachomiranda5151
@nachomiranda5151 2 жыл бұрын
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
@CurbalEN
@CurbalEN 2 жыл бұрын
Hi Nacho, I show it in this video: m.kzfaq.info/get/bejne/a9x8ddGjtd-0l5c.html
@nachomiranda5151
@nachomiranda5151 2 жыл бұрын
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
@CurbalEN
@CurbalEN 2 жыл бұрын
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 ?
@nachomiranda5151
@nachomiranda5151 2 жыл бұрын
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
@CurbalEN
@CurbalEN 2 жыл бұрын
I am not really understanding the use case, so my answers are not very useful, sorry!
@tejasbrahmbatt5344
@tejasbrahmbatt5344 2 жыл бұрын
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..
@adnanmustafa73
@adnanmustafa73 2 жыл бұрын
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.
@CurbalEN
@CurbalEN 2 жыл бұрын
I don’t know if that is possible
@lucaspessanhasantana5341
@lucaspessanhasantana5341 2 жыл бұрын
What is the version that has this options? I'm running a version of January 2022 and I can't find it.
@xatifx
@xatifx 2 жыл бұрын
I think it was made available in May version
@mabenba
@mabenba 2 жыл бұрын
Nowadays everyone is talking about field parameters. Thanks for sharing this clarifying tutorial!
@CurbalEN
@CurbalEN 2 жыл бұрын
You welcome , they are neat if used properly :)
@datareggibi
@datareggibi 2 жыл бұрын
awesome @curbal
@Theshashidharpatil
@Theshashidharpatil 2 жыл бұрын
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!
@CurbalEN
@CurbalEN 2 жыл бұрын
Sure, I think it is this one: Will datamarts become the online version of Power BI Desktop? kzfaq.info/get/bejne/j89-m7aemd-5pps.html
@Theshashidharpatil
@Theshashidharpatil 2 жыл бұрын
@@CurbalEN Thank you!
@Michael-mt6kx
@Michael-mt6kx 2 жыл бұрын
Can we create a dropdown menu from these field parameters?
@CurbalEN
@CurbalEN 2 жыл бұрын
Like a slicer?
@Michael-mt6kx
@Michael-mt6kx 2 жыл бұрын
@@CurbalEN yes, but in a dropdown menu
@CurbalEN
@CurbalEN 2 жыл бұрын
Yes, just change the slicer type :)
@Michael-mt6kx
@Michael-mt6kx 2 жыл бұрын
@@CurbalEN could there be a reason why this is not working?
@CurbalEN
@CurbalEN 2 жыл бұрын
Maybe the theme ? Change it to see if it works better
@zoranagrkovic8796
@zoranagrkovic8796 Жыл бұрын
Do you know maybe when it will be general ? 😭😭😭😭
@CurbalEN
@CurbalEN Жыл бұрын
Nope :(
@oksanavorobiova8929
@oksanavorobiova8929 2 жыл бұрын
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) kzfaq.info/get/bejne/nb-SerGWvqqYf40.html ) , is feature like 'Field parameters' replacing those video?
@jayantsharma3031
@jayantsharma3031 2 жыл бұрын
Sorry to say but this seems more like a thinking-out-loud video than a well-thought through and polished one.
@CurbalEN
@CurbalEN 2 жыл бұрын
It might seem that way, but there are many many hours spent on this video. Care to develop why you feel that way?
@antonycatella5901
@antonycatella5901 2 жыл бұрын
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 KZfaq channel to demonstrate what a 'well-thought through and polished video' is?
Fields Parameter in Action I Practical Examples
15:14
How to Power BI
Рет қаралды 120 М.
Pleased the disabled person! #shorts
00:43
Dimon Markov
Рет қаралды 29 МЛН
Они так быстро убрались!
01:00
Аришнев
Рет қаралды 1,3 МЛН
Эффект Карбонаро и нестандартная коробка
01:00
История одного вокалиста
Рет қаралды 10 МЛН
5 DESIGN TRICKS that Make EVERY Power BI Report Look GREAT!
20:22
How to Power BI
Рет қаралды 554 М.
Using Power BI Field Parameters to add Measure Slicers to a Report
9:38
Fields parameters in Power BI
20:38
SQLBI
Рет қаралды 76 М.
3 Power BI Visuals You Haven't Seen Before!
17:19
How to Power BI
Рет қаралды 37 М.