NEW! Dynamic Slicers with Fields Parameters | ULTIMATE EXAMPLE in Power BI

[@Been_8]

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

[@jasonabbott3874]

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.

[@zacharyfriedman8709]

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.

[@electron6825]

@@zacharyfriedman8709 in my case, I had to sort the months by a month number column in the data model

[@paulgallagher2987]

Yeah I've found this a great use case too.

[@joachimtaelman7344]

Can you give an example or a sample code for that?

[@agelee89]

i added date to tooltips and order by date

[@seth3681]

This is an awesome capability, I’ve been building dynamic drill paths into my matrix visuals using field parameters and my users love it

[@vladimirlisovskiy6518]

Awesome would be to have matrix column written vertically... 😎 👌

[@gregg4636]

@@vladimirlisovskiy6518 And measure for counting % withing group too

[@alicedwonderland7733]

the best Power BI channel on KZbin, hands down!

[@PedroCabraldaCamara]

Thanks a lot Bas. Your videos are always fun to watch. Can't miss any

[@HowtoPowerBI]

I appreciate that Pedro :)

[@wojpaw5362]

I love your content🤩You're the PBI expert work mate who I never had.

[@HowtoPowerBI]

Happy to hear that!

[@rohansrivastava6610]

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 🤪

[@HowtoPowerBI]

thanks and good luck! :)

[@venkat8071]

I always enjoy watching your Videos Bas! Thank you so much Bas!

[@MariaI-d2c]

just perfect! Thank you for this inspiring part!

[@JohnOttoKnoke]

Blew my mind. I'm just using what you showed us In my working protect. Thanks

[@HowtoPowerBI]

Glad you find this useful :)

[@kentcowthe]

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?

[@ladegaanthony1376]

Thank you. You're saving livelihoods

[@HowtoPowerBI]

Oh oh :) thx but that’s too much pressure ;)

[@camilaquebec6222]

Thank you Bas, I'll be trying it in one of my models, hopping the Nov 22 version is available

[@rileywells3045]

Helped me out so much, thank you!!!

[@boqunyin2797]

Thank you so much! That's exactly what I want!

[@hariprasad289]

Awesome, great. Thank you very much sharing very interesting points

[@cristophermartinez8195]

i love this new function. thanks for the video

[@HowtoPowerBI]

Glad you like it Cristopher!

[@ricardopinxt212]

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 😉

[@unnikrishnansanthosh]

wonderful BAS, thank you for sharing

[@AA_fromtexas]

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

[@didijaba]

Very good tips, thanks

[@HowtoPowerBI]

Glad it was helpful!

[@just1live]

Great one! ...waiting for gradient colors in Power BI

[@HowtoPowerBI]

me2 !

[@adilfaizanrazvi929]

Superb ! In detail explanation 💯📊

[@JekVlada]

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!

[@RomanFilimonov]

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.

[@DriveForBetter]

You're a legend, Bas!

[@thrivikram1978]

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?

[@EnriqueFajardo-rx8so]

Great video, thanks for sharing your knowledge. I have one additional challenge. How can I set up default selected values for field parameter slicers

[@tibobago]

Bookmarks are probably an option

[@inderr7bajaj]

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...

[@HowtoPowerBI]

agree agree agree! :)

[@aucesarbr]

Best Professor with best content!

[@HowtoPowerBI]

Thx Augusto!

[@anastassiyasuprunova7875]

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.

[@CONTROLREROOM]

This is brilliant! Thanks

[@szklydm]

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!

[@MoAli-j3s]

can someone share the link to the work around video he mentioned at @13:59

[@TimePasser]

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

[@arpitbhateley544]

For some reason, PBI has discontinued this Show selected option for the slicer. Is there any work around on that?

[@JOSEN-xj5kw]

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

[@lovlyhearts288]

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.

[@twkyoscr]

Hi Bas, thanks for this really great content. Is there a way to add a Top5 Category in the parameter?

[@taldir3361]

You are just fabulous Thank

[@HowtoPowerBI]

thx Taldir!

[@klebersanto50]

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?

[@HowtoPowerBI]

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

[@leroypalmer9226]

@@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

[@ScienceBehindSayings]

This is Awesome feature, i saw this functionality with combination of inactive active relationships, 2 months back on " PowerBIHelpline " channel.

[@nikilouw1878]

Hi Bas Do you know how to implement Field Parameters when using Tabular Model?

[@hannahgilbert3467]

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?

[@dianamarcelacarreropinto3331]

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.

[@oliviahowing9104]

Is it possible to do this with different date fields? I tried using USRELATIONSHIP but that doesnot work

[@andruboine]

This helps eliminate some bookmark stacking visuals I have

[@HowtoPowerBI]

Cool!

[@fahmywaleed]

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

[@chriskeo392]

Can we use drop down date slicer for this yet?

[@smritikarki7508]

Is field parameter available only in paid version or it is avail in free version of power bi also?

[@emceesnypher]

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.

[@titusdinkar]

Love your content! Do you think the usage of bookmarks allow the sorting order to stay for now until they make an update?

[@touahrikarim8562]

Hello, do you any idea how could we set a dynamic default value of slicer ?

[@saikumar-uu8ze]

i want to return blank if there is no selection in the slicer is that possible?

[@asjones987]

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.

[@matprest]

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?

[@HowtoPowerBI]

Feature didnt exist yet when this was recorded

[@mcbgun1]

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

[@sanumpzha]

Nice video Bas.👍

[@klebersanto50]

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

[@nicolasplanchon9986]

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 :)

[@saa-imanatha5355]

Can anyone please link the video where he solves the sort issue? :)

[@chaitanyalanka7043]

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

[@kassiowifried]

Great. You are the Best.

[@HowtoPowerBI]

Thank you so much 😀

[@pharmacyinsight]

How to achive this functionality without field parameter? I am using Power BI RS version and it doesnt have this field parameter yet.

[@aldinoa9230]

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?

[@gregg4636]

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

[@reshminair6747]

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.

[@totvabe1]

Awesome! As usual.

[@HowtoPowerBI]

:) happy to see you here! thanks

[@allaboutfoodzbydebd8627]

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?

[@prashantadhiakri2964]

Can i ask questions to solve the table. Please reply.

[@חייםחדד-ח2מ]

How to use this dynamic slicer to filter the visuals by multiple fields ??!!

[@sagarnayak98]

Love you Bro ❤

[@ajinkyacgaikwad]

Dynamic titles for a text box dont work with Field parameters. Could you please come up with a solution for the same?

[@pl4195]

is there any update on field parameter on this issue ?😢

[@lucioBLUTM]

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. 🤟🏻

[@Haoren85]

Based on the above example, wouldn’t simple filters work?

[@the_creator99]

Impressive!

[@rakeshbond009]

When we switch between parameters it takes off my existing sorting settings. Any idead to fix it.

[@novyrrsecret]

This I would love to know too!

[@nareshvellampalli6696]

How to get selected field parameter using DAX

[@caiquebeck]

Show... tks!

[@gopyjs6216]

🐐🐐

[@changeyourmind-p1n]

A thousand likes

[@HowtoPowerBI]

:) happy to read this!

[@narendrababu2287]

👏👏

[@HowtoPowerBI]

thx!

[@narendrababu2287]

@@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. 😘

[@MrLalramchhana]

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 KZbin channel comment is closed😂😂

[@napjohn88]

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.

[@HowtoPowerBI]

:)

[@Wzxxx]

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.

[@sairam9369]

Always Awesome