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 🙂.
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
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 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!
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
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.
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" ))
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.
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.
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?
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
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
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
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.
Do you have a video on how to use Field Parameters inside DAX... Specifically with DAX functions like "ALLSELECTED" and other dimension type functions.
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
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@@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
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
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!
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.
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..
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) ua-cam.com/video/gYbGNeYD4OY/v-deo.html ) , is feature like 'Field parameters' replacing those video?
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 UA-cam channel to demonstrate what a 'well-thought through and polished video' is?
![[UA] NAVI vs MOUZ | BO5 | IEM Rio 2024](http://i.ytimg.com/vi/CMBYk0cbGoA/mqdefault.jpg)
This is so good; saves having to create extra dim tables. THANK YOU!
Thank you so much! I was struggling with the composite key error and your video solved my problem.
Fab to hear!
Thanks Again Ruth! I really appreciate all you do for the Power BI community.
Thanks 😊!
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 !
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:)
Thank you so much Ruth, you saved my day!
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!
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!
👏👏
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
You saved me with this one! Thank you!!!
That's amazing. Your are a life saver.
Nowadays everyone is talking about field parameters. Thanks for sharing this clarifying tutorial!
You welcome , they are neat if used properly :)
Wow! What a great video, Ruth. Saludos
Muchas gracias y saludos!
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!!
So cool and easy to understand!
They're almost as cool as you, Ruth. I love all your videos and this one doesn't disappoint. Thank you 😊
Thank you Joanne ❤️!
That's really cool, you saved my day madam.
Creative solution and extremely helpful!!
Thanks!
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 :(
Great, video!!! Tks!!!
Thanks Ruth! Very useful
Un placer :)
Never long videos, keep going
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" ))
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.
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
Nice trick to conditional format!
Thanks! :)
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.
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
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
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 ?
can we do the same without field parameters?
if yes, can you share the link or article on it
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.
Do you have a video on how to use Field Parameters inside DAX... Specifically with DAX functions like "ALLSELECTED" and other dimension type functions.
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
HI MAM COULD YOU PLEASE MAKE A VIDEO ON Market Basket Analysis ....
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.ua-cam.com/video/5vLBnrPyPgc/v-deo.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!
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?
ua-cam.com/video/YiNhSm4yUvg/v-deo.html
@@CurbalEN Thank you!
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
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
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
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..
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) ua-cam.com/video/gYbGNeYD4OY/v-deo.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 UA-cam channel to demonstrate what a 'well-thought through and polished video' is?
awesome @curbal