Whaaaaaat? This is so awesome! It worked much better than I thought. I ended up using a Field Switch Slicer that in the same drop down has two levels of selection. It now allows me to click on a Category and then sub-category within the same dropdown! Very cool! Thank you so much for giving this secret away! Subscribed and liked!
I've found the field parameter quite useful to make it easier for users to change date depth on a chart e.g. Month / Week / Day, rather than them learning around the drill down arrows.
How did you make the months not go in alphabetical order? That's the main issue I ran into and your use-case is exactly what I thought field parameters would be best for too.
You are just a wizard, Bas! I really appreciate you posting new content regularly... I am definitely asking my boss for a pay raise after using this on one of my reports 🤪
Newbi to PowerBi here, @How to Power BI, you are my prayers coming true! I've watched all of your videos more or less now (multiple times). Quick question, can I use this to Select Financial Year and then afterwards select Quarter I want to show?
Thanks a lot for this, Bas. There are a few other channels, but your explanations are normally best for me. Question: instead of using 2 connected slicers there should be a way to combine them into 1 hierarchy slicer. Tried, but it doesn't work. Just wondering if you may check this.
Great as usual Bas! Field parameters are great....but indeed...losing the sort order is really a big pain in the... 🤣. Will have to wait for your workaround video or untill Power BI fixes this 😉
Man before I used bookmarks to overlay identical visualizations which was incredibly tedious and maintenance intensive (prone to human error if you changed one visual and forgot to change the rest)…. This is a game changer
I remember mimicking this couple of years back by creating additional dimension tables and was feeling like top of the world after that...😅 Now it's a matter of few clicks... Power BI really came a long way... But still a long way to go from visualization perspective...
Hi! I have a question. Not sure if this is a bug on parameter slicers. So using your example, lets say your field switch is set to productcategory and i select "Computers" on your bar chart, when i switch the parameter to StoreName, the items shown on bar chart wont be filtered to "Computers". Any help would be greatly appreciated. Thanks!
This is very interesting. Can I have only option for one field parameter. Can we have only one field Product Category instead of both and then display the charts?
Haven't tested this functionality myself so I'm wondering if the slicer selections persist if you switch to the other field parameter. Thanks Bas for the video!
Hi Bas, this is a great video. I have a bit unrelated question. How did you display quarter and year as you have it on 9:02 min? I like how you see each quarter by year.
Thank you very much .. this is really helpful. Thank you for the simplification in explaintion. I have a question though. Any idea how how to toggle a line chart from single line to multiline ? For instance, I have 5 stores.. i can get average of sales of all of them. Or the average of each in separate graphs.. I can't wrap my head how to make a toggle switch or slicer to reuse same graph. Any guide or idea would be much appreciated
Hi Buss, do you have a technique or solution on how to use DAX or any other method using a button to set as a default the first record in a table visual in PBI. I have a table visual with a list of names with a add_date on the first column and want to make sure that when the user opens this page in PBI the first row is selected. I love your clarity and way of explaining things on technical solutions. Hope to hear from you soon
Thanks for the video, I am using same technique but getting error in this sequence. User selects option in main slicer then option in sub slicer, then selects the other option in the main slicer but when selecting any option in the sub slicer error in all dashboard visuals "We can't display this visual because a measure is used in cross highlithing, please remove the measure or cross highlight". Looks like the user need to clear sub slicer selections before changing main slicer
As of today do you have a solution for field parameter sorting issue ? If you already posted video before please mention it that would help to know the work around.
thanks for this its really helpful! each of the fields in my parameter have a value of 'blank'. I'd like to default the slicer to filter out 'blank' on report load but allow the user to add 'blank' in if they desire. Do you know if there is a way around this?
Hi, This is quite helpful, but I am trying to have a slicer that takes the values of the selected column and allows me to selected from the numerical values. What you show is the options of that column but it is a categorical column, how can I do when this selected column is a numerical column?. Thanks.
How can we create single date using two dates if we select one date it should show the data related to that date and we change the date it has to show the data related to that date in power bi
Hallo Bas, Would you know how to combine this tuto with the other tuto you performed on switching between percentage and absolute values please ? When trying to switch between absolute and % value on a graph with field parameters it doesn't quite seem to work unfortunately. Thanks in advance :)
This is great. Was anyone else wondering why, at the 13 minute mark, he didn't just use "Reverse stack order" on the main bar chart instead of the legend chart? Have I missed something?
How do you maintain your drill level on your dates? I've set up as you have but whenever I select quarter it only picks 2022 data not 2021 & 2022....so effectively I can get it to work for only one specific year selection
Is there a way to have a filed parameter slicer work so when you select an item in a slicer it will swap several preselected items when a slicer is selected. I know I could have the end users select multiple items. However certain things go with each other and thus it would be better to have 2 or 3 items in a slicer than 6-8 items. It seems like there should be a way to do this.
you are using Power BI Report Server version (has no preview features and field parameters) .. you would need to download the "normal" power bi version
@@HowtoPowerBI I am having the same challenge. If I publish my reports to a report server and want this functionality; is a workaround possible? Ps. I have been researching and have not come across a solution
Hello Bass, I would like to add in a Power BI report server a persistent filter. I mean, Filters that the each end user needed, be somehow saved by them. In other words, the Filters applied by each user can be automatically again applied when users return to view report. Then, depending on each user, they can open the report with the filters applied according to their needs. This would make each user's work more efficient. Would this be possible? Thanks master !! Kleber
I have a question, lets say I have 4 fields, L4 Dollars, L8 Dollars and L4 Units and L8 Units - is it possible to build a Field Parameter where it switches between Dollars and Units where both Fields Change?
Is there a workaround for this for an older version ? My Power BI Desktop version is 2.109.782.0 64-bit (September 2022) and I'm not sure if I'll get an approval from my organization to update it.
Hi... I have a requirement at my ofc where we have 100 columns , out of those there are 15 measure fields n rest are dimensions . Now we have already implemented this logic to dynamically choose dimension n measure columns to get data. Now there is a filter panel created from where client can select particular brand,product,market and so on. He wants to add all 85 dimensional fields in filters without increasing canvas size . How to achieve that? Can you help?
Show us how to make mutable set of columns(grouping hierarchy) in the Matrix viz and properly calculate % within group. User can select any combination of fields in the parameter and order of selection being reflected as grouping hierarchy
Struggling to solve a filter selection problem. Here's my problem statement: Let's say, I have 2 filters, country and order_dt. I always want the country slicer to show all countries in the list but only the respective order_dt for the country and the visuals should change according to these 2 filter selections. Hence, I used edit interactions to not let ord_dt filter my country slicer. Now, when I have selected a country (ex: US) and ord_dt (ex: 13th Feb, 2022), the visuals change accordingly but now when I change the country to say, UK- all my visuals go blank because I don't have an ord_dt= 13th Feb, 2022 for UK. Is there a way to automatically select another ord_dt which is available for UK instead of sticking to the one which was selected for US previously? This is resolved only when I manually select another date.
For some visuals where you can’t sort by the original order from table.. like MonthName by MonthNum, I could add the “hide” field “Order” that is created in FieldParameters table. After adding the Order field in the visual, in “small multiples” for instance, the order by get to work automatically. Just have to change the settings setup just one column and row. 🤟🏻
@@HowtoPowerBI always we can just do is clapping. the way you try to explain the subject in a simplest way with your examples is always best part in your videos. we love it. 😘
The new power Bi updates got a bugs.. try pie chart it will turn into donut chart.. and details label color of words cannot be change..i try to report it but thier RUclips channel comment is closed😂😂
This does not work for canned reporting and other reports. Kinda a half ass attempt. This is not a good idea. A heatmap would be better solution and for large organizations this is not feasible. You do not really address items for corporate reporting. More look what I did at home charts.
I use a filed parameter to choose a slice category on X axis. I would like to automatically choose a parameter based on other measure (not on outer slicer) how to do it? I test everything but it seems impossible. So if some measure is on then slice X by field 1, if it is 2 then slice measure by filed 2 etc.
Whaaaaaat? This is so awesome! It worked much better than I thought. I ended up using a Field Switch Slicer that in the same drop down has two levels of selection. It now allows me to click on a Category and then sub-category within the same dropdown! Very cool! Thank you so much for giving this secret away!
Subscribed and liked!
So much to learn from you mate. Like the way you deep dive into dax and shows things end to end ...lucky to find your content
the best Power BI channel on RUclips, hands down!
I've found the field parameter quite useful to make it easier for users to change date depth on a chart e.g. Month / Week / Day, rather than them learning around the drill down arrows.
How did you make the months not go in alphabetical order? That's the main issue I ran into and your use-case is exactly what I thought field parameters would be best for too.
@@zacharyfriedman8709 in my case, I had to sort the months by a month number column in the data model
Yeah I've found this a great use case too.
Can you give an example or a sample code for that?
i added date to tooltips and order by date
This is an awesome capability, I’ve been building dynamic drill paths into my matrix visuals using field parameters and my users love it
Awesome would be to have matrix column written vertically... 😎 👌
@@vladimirlisovskiy6518 And measure for counting % withing group too
Thanks a lot Bas. Your videos are always fun to watch. Can't miss any
I appreciate that Pedro :)
You are just a wizard, Bas! I really appreciate you posting new content regularly... I am definitely asking my boss for a pay raise after using this on one of my reports 🤪
thanks and good luck! :)
I love your content🤩You're the PBI expert work mate who I never had.
Happy to hear that!
Newbi to PowerBi here, @How to Power BI, you are my prayers coming true! I've watched all of your videos more or less now (multiple times). Quick question, can I use this to Select Financial Year and then afterwards select Quarter I want to show?
I always enjoy watching your Videos Bas! Thank you so much Bas!
Thank you. You're saving livelihoods
Oh oh :) thx but that’s too much pressure ;)
just perfect! Thank you for this inspiring part!
Thanks a lot for this, Bas. There are a few other channels, but your explanations are normally best for me.
Question: instead of using 2 connected slicers there should be a way to combine them into 1 hierarchy slicer. Tried, but it doesn't work. Just wondering if you may check this.
Great as usual Bas! Field parameters are great....but indeed...losing the sort order is really a big pain in the... 🤣. Will have to wait for your workaround video or untill Power BI fixes this 😉
Blew my mind. I'm just using what you showed us In my working protect. Thanks
Glad you find this useful :)
Man before I used bookmarks to overlay identical visualizations which was incredibly tedious and maintenance intensive (prone to human error if you changed one visual and forgot to change the rest)…. This is a game changer
Thank you Bas, I'll be trying it in one of my models, hopping the Nov 22 version is available
Best Professor with best content!
Thx Augusto!
You're a legend, Bas!
Thank you so much! That's exactly what I want!
Superb ! In detail explanation 💯📊
Helped me out so much, thank you!!!
Great one! ...waiting for gradient colors in Power BI
me2 !
i love this new function. thanks for the video
Glad you like it Cristopher!
I remember mimicking this couple of years back by creating additional dimension tables and was feeling like top of the world after that...😅
Now it's a matter of few clicks... Power BI really came a long way... But still a long way to go from visualization perspective...
agree agree agree! :)
Hi! I have a question. Not sure if this is a bug on parameter slicers.
So using your example, lets say your field switch is set to productcategory and i select "Computers" on your bar chart, when i switch the parameter to StoreName, the items shown on bar chart wont be filtered to "Computers".
Any help would be greatly appreciated. Thanks!
Very good tips, thanks
Glad it was helpful!
For some reason, PBI has discontinued this Show selected option for the slicer. Is there any work around on that?
This is very interesting. Can I have only option for one field parameter. Can we have only one field Product Category instead of both and then display the charts?
Awesome, great. Thank you very much sharing very interesting points
Great video, thanks for sharing your knowledge. I have one additional challenge. How can I set up default selected values for field parameter slicers
Bookmarks are probably an option
Love your content! Do you think the usage of bookmarks allow the sorting order to stay for now until they make an update?
Haven't tested this functionality myself so I'm wondering if the slicer selections persist if you switch to the other field parameter. Thanks Bas for the video!
Hi Bas, this is a great video. I have a bit unrelated question. How did you display quarter and year as you have it on 9:02 min? I like how you see each quarter by year.
This is brilliant! Thanks
can someone share the link to the work around video he mentioned at @13:59
wonderful BAS, thank you for sharing
Hi Bas, thanks for this really great content. Is there a way to add a Top5 Category in the parameter?
Thank you very much .. this is really helpful. Thank you for the simplification in explaintion. I have a question though. Any idea how how to toggle a line chart from single line to multiline ? For instance, I have 5 stores.. i can get average of sales of all of them. Or the average of each in separate graphs.. I can't wrap my head how to make a toggle switch or slicer to reuse same graph. Any guide or idea would be much appreciated
Hi Buss, do you have a technique or solution on how to use DAX or any other method using a button to set as a default the first record in a table visual in PBI.
I have a table visual with a list of names with a add_date on the first column and want to make sure that when the user opens this page in PBI the first row is selected.
I love your clarity and way of explaining things on technical solutions.
Hope to hear from you soon
Thanks for the video, I am using same technique but getting error in this sequence. User selects option in main slicer then option in sub slicer, then selects the other option in the main slicer but when selecting any option in the sub slicer error in all dashboard visuals "We can't display this visual because a measure is used in cross highlithing, please remove the measure or cross highlight". Looks like the user need to clear sub slicer selections before changing main slicer
i want to return blank if there is no selection in the slicer is that possible?
As of today do you have a solution for field parameter sorting issue ? If you already posted video before please mention it that would help to know the work around.
This helps eliminate some bookmark stacking visuals I have
Cool!
Nice video Bas.👍
Is it possible to do this with different date fields? I tried using USRELATIONSHIP but that doesnot work
You are just fabulous
Thank
thx Taldir!
Can we use drop down date slicer for this yet?
thanks for this its really helpful!
each of the fields in my parameter have a value of 'blank'. I'd like to default the slicer to filter out 'blank' on report load but allow the user to add 'blank' in if they desire. Do you know if there is a way around this?
Hello, do you any idea how could we set a dynamic default value of slicer ?
Hi,
This is quite helpful, but I am trying to have a slicer that takes the values of the selected column and allows me to selected from the numerical values. What you show is the options of that column but it is a categorical column, how can I do when this selected column is a numerical column?. Thanks.
How to use this dynamic slicer to filter the visuals by multiple fields ??!!
How can we create single date using two dates if we select one date it should show the data related to that date and we change the date it has to show the data related to that date in power bi
Hi Bas
Do you know how to implement Field Parameters when using Tabular Model?
Great.
You are the Best.
Thank you so much 😀
Love you Bro ❤
Hallo Bas,
Would you know how to combine this tuto with the other tuto you performed on switching between percentage and absolute values please ?
When trying to switch between absolute and % value on a graph with field parameters it doesn't quite seem to work unfortunately.
Thanks in advance :)
Is field parameter available only in paid version or it is avail in free version of power bi also?
This is great. Was anyone else wondering why, at the 13 minute mark, he didn't just use "Reverse stack order" on the main bar chart instead of the legend chart? Have I missed something?
Feature didnt exist yet when this was recorded
This is Awesome feature, i saw this functionality with combination of inactive active relationships, 2 months back on " PowerBIHelpline " channel.
How do you maintain your drill level on your dates? I've set up as you have but whenever I select quarter it only picks 2022 data not 2021 & 2022....so effectively I can get it to work for only one specific year selection
Awesome! As usual.
:) happy to see you here! thanks
Can anyone please link the video where he solves the sort issue? :)
Is there a way to have a filed parameter slicer work so when you select an item in a slicer it will swap several preselected items when a slicer is selected. I know I could have the end users select multiple items. However certain things go with each other and thus it would be better to have 2 or 3 items in a slicer than 6-8 items. It seems like there should be a way to do this.
Hello Bas, thank you for the video! My PBI version is of May2023, however, in the options there is no "Preview features". Do you know the reason?
you are using Power BI Report Server version (has no preview features and field parameters) .. you would need to download the "normal" power bi version
@@HowtoPowerBI I am having the same challenge. If I publish my reports to a report server and want this functionality; is a workaround possible?
Ps. I have been researching and have not come across a solution
Hello Bass, I would like to add in a Power BI report server a persistent filter. I mean, Filters that the each end user needed, be somehow saved by them. In other words, the Filters applied by each user can be automatically again applied when users return to view report. Then, depending on each user, they can open the report with the filters applied according to their needs. This would make each user's work more efficient.
Would this be possible?
Thanks master !!
Kleber
Can i ask questions to solve the table. Please reply.
I have a question, lets say I have 4 fields, L4 Dollars, L8 Dollars and L4 Units and L8 Units - is it possible to build a Field Parameter where it switches between Dollars and Units where both Fields Change?
Dynamic titles for a text box dont work with Field parameters. Could you please come up with a solution for the same?
How to achive this functionality without field parameter? I am using Power BI RS version and it doesnt have this field parameter yet.
Is there a workaround for this for an older version ? My Power BI Desktop version is 2.109.782.0 64-bit (September 2022) and I'm not sure if I'll get an approval from my organization to update it.
Hi... I have a requirement at my ofc where we have 100 columns , out of those there are 15 measure fields n rest are dimensions . Now we have already implemented this logic to dynamically choose dimension n measure columns to get data. Now there is a filter panel created from where client can select particular brand,product,market and so on. He wants to add all 85 dimensional fields in filters without increasing canvas size . How to achieve that? Can you help?
When we switch between parameters it takes off my existing sorting settings. Any idead to fix it.
This I would love to know too!
Impressive!
Based on the above example, wouldn’t simple filters work?
is there any update on field parameter on this issue ?😢
Show us how to make mutable set of columns(grouping hierarchy) in the Matrix viz and properly calculate % within group. User can select any combination of fields in the parameter and order of selection being reflected as grouping hierarchy
How to get selected field parameter using DAX
Struggling to solve a filter selection problem. Here's my problem statement: Let's say, I have 2 filters, country and order_dt. I always want the country slicer to show all countries in the list but only the respective order_dt for the country and the visuals should change according to these 2 filter selections. Hence, I used edit interactions to not let ord_dt filter my country slicer. Now, when I have selected a country (ex: US) and ord_dt (ex: 13th Feb, 2022), the visuals change accordingly but now when I change the country to say, UK- all my visuals go blank because I don't have an ord_dt= 13th Feb, 2022 for UK. Is there a way to automatically select another ord_dt which is available for UK instead of sticking to the one which was selected for US previously? This is resolved only when I manually select another date.
Always Awesome
🐐🐐
For some visuals where you can’t sort by the original order from table.. like MonthName by MonthNum, I could add the “hide” field “Order” that is created in FieldParameters table.
After adding the Order field in the visual, in “small multiples” for instance, the order by get to work automatically. Just have to change the settings setup just one column and row. 🤟🏻
Show... tks!
👏👏
thx!
@@HowtoPowerBI always we can just do is clapping. the way you try to explain the subject in a simplest way with your examples is always best part in your videos. we love it. 😘
A thousand likes
:) happy to read this!
The new power Bi updates got a bugs.. try pie chart it will turn into donut chart.. and details label color of words cannot be change..i try to report it but thier RUclips channel comment is closed😂😂
This does not work for canned reporting and other reports. Kinda a half ass attempt. This is not a good idea. A heatmap would be better solution and for large organizations this is not feasible. You do not really address items for corporate reporting. More look what I did at home charts.
:)
I use a filed parameter to choose a slice category on X axis. I would like to automatically choose a parameter based on other measure (not on outer slicer) how to do it? I test everything but it seems impossible. So if some measure is on then slice X by field 1, if it is 2 then slice measure by filed 2 etc.