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

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

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

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

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

[@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! :)

[@wojpaw5362]

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

[@HowtoPowerBI]

Happy to hear that!

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

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

[@PedroCabraldaCamara]

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

[@HowtoPowerBI]

I appreciate that Pedro :)

[@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! :)

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

[@camilaquebec6222]

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

[@JohnOttoKnoke]

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

[@HowtoPowerBI]

Glad you find this useful :)

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

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

[@MariaI-d2c]

just perfect! Thank you for this inspiring part!

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

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

[@venkat8071]

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

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

[@ladegaanthony1376]

Thank you. You're saving livelihoods

[@HowtoPowerBI]

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

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

[@just1live]

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

[@HowtoPowerBI]

me2 !

[@ScienceBehindSayings]

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

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

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

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

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

[@hariprasad289]

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

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

[@twkyoscr]

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

[@nikilouw1878]

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

[@adilfaizanrazvi929]

Superb ! In detail explanation 💯📊

[@cristophermartinez8195]

i love this new function. thanks for the video

[@HowtoPowerBI]

Glad you like it Cristopher!

[@titusdinkar]

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

[@aucesarbr]

Best Professor with best content!

[@HowtoPowerBI]

Thx Augusto!

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

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

[@smritikarki7508]

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

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

[@unnikrishnansanthosh]

wonderful BAS, thank you for sharing

[@chriskeo392]

Can we use drop down date slicer for this yet?

[@CONTROLREROOM]

This is brilliant! Thanks

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

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

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

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

[@dmv483]

Just wondering if you can use Dynamic Slicers on measures. For instance enabling the user to switch a view between sum of sales and sum of units, keeping the dimension the same? Thanks.

[@marcmason3514]

This can be done using Slicers and IF Measures. For example I have a column named "Metric" which is used in a slicer which has "Volume" and "Value". I also have a Sales Volume Measure and a Sales Value Measure. I would write a measue IF(SELECTEDVALUE(MetricColumn) = 'Volume',[ SalesVolume],[SalesValue])

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

[@arpitbhateley544]

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

[@touahrikarim8562]

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

[@pharmacyinsight]

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

[@ajinkyacgaikwad]

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

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

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

[@prashantadhiakri2964]

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

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

[@saikumar-uu8ze]

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

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

[@ArmandoJeannot]

Thanks a lot mate 😀

[@HowtoPowerBI]

Any time!

[@saa-imanatha5355]

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

[@sanumpzha]

Nice video Bas.👍

[@taldir3361]

You are just fabulous Thank

[@HowtoPowerBI]

thx Taldir!

[@nareshvellampalli6696]

How to get selected field parameter using DAX

[@pl4195]

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

[@sagarnayak98]

Love you Bro ❤

[@kassiowifried]

Great. You are the Best.

[@HowtoPowerBI]

Thank you so much 😀

[@totvabe1]

Awesome! As usual.

[@HowtoPowerBI]

:) happy to see you here! thanks

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

[@the_creator99]

Impressive!

[@caiquebeck]

Show... tks!

[@gopyjs6216]

🐐🐐

[@claudiozadorosny4722]

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]

:)

[@sairam9369]

Always Awesome

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