This is so good; saves having to create extra dim tables. THANK YOU!
@mounica80
2 жыл бұрын
Thank you so much! I was struggling with the composite key error and your video solved my problem.
@CurbalEN
2 жыл бұрын
Fab to hear!
@ThreadRider
2 жыл бұрын
Thanks Again Ruth! I really appreciate all you do for the Power BI community.
@CurbalEN
2 жыл бұрын
Thanks 😊!
@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
Жыл бұрын
My pleasure !
@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
2 жыл бұрын
Wonderful:)
@olgaitskova8542
8 ай бұрын
Thank you so much Ruth, you saved my day!
@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
2 жыл бұрын
Thanks!
@pmenown
2 жыл бұрын
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
2 жыл бұрын
👏👏
@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
@theexperienceof...5357
2 жыл бұрын
You saved me with this one! Thank you!!!
@SarahTran1240
3 ай бұрын
That's amazing. Your are a life saver.
@mabenba
2 жыл бұрын
Nowadays everyone is talking about field parameters. Thanks for sharing this clarifying tutorial!
@CurbalEN
2 жыл бұрын
You welcome , they are neat if used properly :)
@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
2 жыл бұрын
Didn’t know, thanks!!
@JohnOttoKnoke
2 жыл бұрын
Wow! What a great video, Ruth. Saludos
@CurbalEN
2 жыл бұрын
Muchas gracias y saludos!
@JOSERAULESQUIVELUGARTE
11 ай бұрын
So cool and easy to understand!
@joanneosborne2428
2 жыл бұрын
They're almost as cool as you, Ruth. I love all your videos and this one doesn't disappoint. Thank you 😊
@CurbalEN
2 жыл бұрын
Thank you Joanne ❤️!
@slasher4328
Жыл бұрын
That's really cool, you saved my day madam.
@juniorholder1230
2 жыл бұрын
Creative solution and extremely helpful!!
@CurbalEN
2 жыл бұрын
Thanks!
@lukaszjaniszewski2094
2 жыл бұрын
Thanks for those tips. I am waiting for parameter that also can change type of visual, not only measure
@CurbalEN
2 жыл бұрын
I think someone did that already but can’t remember who :(
@aleksvpYT
Жыл бұрын
Great, video!!! Tks!!!
@cesarramos3569
2 жыл бұрын
Thanks Ruth! Very useful
@CurbalEN
2 жыл бұрын
Un placer :)
@cathrerinezetadrones3169
Жыл бұрын
Never long videos, keep going
@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" ))
@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
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
2 жыл бұрын
Yes, less things to load and easier to maintain imo
@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
@skalsolutions
2 жыл бұрын
Nice trick to conditional format!
@CurbalEN
2 жыл бұрын
Thanks! :)
@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.
@digdin12345
2 жыл бұрын
Thanks and great! , where can i download the pbix file ?
@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
2 жыл бұрын
Great!
@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
@kajalsharma5889
10 ай бұрын
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
@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
2 жыл бұрын
Maybe it is not possible yet?
@heniekheniek1781
2 жыл бұрын
exactly, why no one mentions this? users will have to sort each time they change a parameter...
@CurbalEN
2 жыл бұрын
In the other visuals it is fine, maybe it is just the matrix? Haven’t tried field parameters there yet
@Truth-N-Lies
Жыл бұрын
Hi, How to select values from, ie "VALUES(field parameter table[column])" for dynamic selection of columns from different table ?
@vaangovaangopakkurathukuva5916
2 жыл бұрын
can we do the same without field parameters? if yes, can you share the link or article on it
@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.
@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.
@carlosalvarez-cascos5225
2 жыл бұрын
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
@gagansingh3481
Жыл бұрын
HI MAM COULD YOU PLEASE MAKE A VIDEO ON Market Basket Analysis ....
@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.
@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
2 жыл бұрын
Hi Nacho, I show it in this video: m.kzitem.info/news/bejne/lqyCqKKoiauBmpg
@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
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
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
2 жыл бұрын
I am not really understanding the use case, so my answers are not very useful, sorry!
@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
2 жыл бұрын
Sure, I think it is this one: Will datamarts become the online version of Power BI Desktop? kzitem.info/news/bejne/up-EzoejbauGqZw
@Theshashidharpatil
2 жыл бұрын
@@CurbalEN Thank you!
@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
2 жыл бұрын
I think it was made available in May version
@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
2 жыл бұрын
I don’t know if that is possible
@Michael-mt6kx
2 жыл бұрын
Can we create a dropdown menu from these field parameters?
@CurbalEN
2 жыл бұрын
Like a slicer?
@Michael-mt6kx
2 жыл бұрын
@@CurbalEN yes, but in a dropdown menu
@CurbalEN
2 жыл бұрын
Yes, just change the slicer type :)
@Michael-mt6kx
2 жыл бұрын
@@CurbalEN could there be a reason why this is not working?
@CurbalEN
2 жыл бұрын
Maybe the theme ? Change it to see if it works better
@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..
@zoranagrkovic8796
2 жыл бұрын
Do you know maybe when it will be general ? 😭😭😭😭
@CurbalEN
2 жыл бұрын
Nope :(
@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) kzitem.info/news/bejne/yI-YrYKbknZlgo4 ) , is feature like 'Field parameters' replacing those video?
@jayantsharma3031
2 жыл бұрын
Sorry to say but this seems more like a thinking-out-loud video than a well-thought through and polished one.
@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
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 KZitem channel to demonstrate what a 'well-thought through and polished video' is?
Пікірлер: 86