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 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 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.
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.
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
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.
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
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
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?
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.
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 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 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 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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YiNhSm4yUvg.html
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) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gYbGNeYD4OY.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 RU-vid channel to demonstrate what a 'well-thought through and polished video' is?