Fields parameters in Power BI

This video analyzes the dynamic parameters feature in Power BI, unveiling some of the internals of its implementation.
IMPORTANT: While this feature is in preview, you must enable it in Power BI Desktop in Options / Global / Preview Features / Field parameters. If you do not enable the feature, also the sample file does not work.

[DIGITAL_COOKING]

0:00 introduction to field parameter
2:30 creation of field parameter
5:15 how to edit field parameter(nameof function)
7:09 creation of hierarchy for field parameter
9:09 analyzing queries of field parameter
13:24 be aware of the limitation of field parameter
16:19 how field parameter are stored in the model
19:30 summary and conclusion about field parameter

[Bharath_PBI]

We were waiting for this for many years, as said it's a much needed feature among others (ex. sets)

However, sad to know that this implementation is only at the client level and not at the model level (TOM). But still welcome this feature in power bi. As always, to get deeper insights, sqlbi is the way to go. Thank you 👍

[teunkruijer]

I always wanted this to easily switch between days, weeks, months instead of drilldown/up. Now it is here. All this time spent making custom tables to get this functionality is no more 😀 Great video as always Alberto!

[erivaldolopes]

Indeed. This behind the scenes are truly amazing and insightful. Keep it up Alberto as I learn every time

[matthiask]

I love the "behind the scenes" video. Who would have thought that this is a client-feature, and so is not (yet) working in Excel? Thx, Alberto!

[robscheffler]

Thank you, as always, for going a bit deeper than other youtube BI channels. I've been experimenting with these field parameters and time-intelligence calculation groups. So far, the results are somewhat mixed. I did receive a similar "composite key" error message, but overall, the interaction appears to be working. Maybe as a follow-up video, you could explore calculation groups/items working (or not) with field parameters. Thank you!

[ek-]

Thank you Thank you Thank you.
Finally Power BI did it, this is a very very needed common feature that all BI thing should have.

[mshparber]

Exactly my thoughts: “How does it work behind the scenes!?” Thanks, Alberto!

[frederikhye-hestvang]

Hi Alberto! Great video. How do you work with field parameters, when you're using feature to choose between two measures (not dimensions, as you've shown), and then have both totals, averages, min and max measures in your table? Best, F

[luisfelipefn]

Hey. Is there any way to combine the field parameter and a targeting filter? For example: I created a field parameter with month, week and date. Would like to have a slicer to select a specific period. When I filtered month in the field parameter, for example, my slicer would only have month options. If I select week in the field parameter the slicer would only have weeks.

Is it possible to do that?

[Dias-fpuo]

Thank you for the awesome video! Would it be possible to have nested parameters? For example if I need to have one filter pane with $ Sales / Units. And another filter pane with YTD Spend / YoY growth. So that 2 filters will filter one field?

[majdyazigi]

Thank you Alberto, great as usual!!
But do you agree with me that this is bit confusing to end users because they used to think about slicers as filters not column choosers, can you propuse better visual than slicers to present it to users?
Thanks again

[khorshidsun]

Hello, thanks for your video. It is possible to get the value of measures of field parameter table for conditional formating?

[bernardorufino]

Great video, congrats!
Quick question: let's supose I have 2 field parameters with 2 options each (so total of 4 measures, which are the result of the combinations of those 4 options).
The requirements involve having those 2 field parameters separeted, so I need to display the result from the combined selections. Which way would you recommend to implement?

[kostaskolotouros]

Every time I come back to this video I want to click the like button again!

[eleftheriakoniari]

Hi! Thank you so much for all your videos! Today I found that the order in selection of the fields of a field parameter not always maters. I have a matrix and I am using a field parameter to allow users make their own table. In the Field Parameters I have Columns from my Dimensions Tables (Products, Customers, SalesStructure)
From Products I have selected the ITEM Group, Product Category, Product Subcategory, Brand, Pack Size, Promo etc
From Customers I have the Channel, Chain, Customer
From Sales Structure I have the Manager, SalesPerson
In the Fields Parameters Table I have created a column just for grouping reasons to indicate the table (Products if the column is from Products tables, Customers and SalesStructure) for more tidy look in my slicer.
The problem that I am phasing now (it wasn't at the begging) is when I am selecting with this order
Product Category - Brand - Channel - Pack Size - Promo in my slicer the order in my matrix is different
Product Category - Brand - Pack Size - Channel - Promo.
Why this is happening now? It is a bug?

[priyankamore]

Thank you so much for such detailed video. I am using field parameters in one dataset. I have used that dataset as live connection to build report. I need to import one excel file to this report so I have to convert this live connection to a DirectQuery connection. Because of which my field parameter queries have become table and Not working as it supposed to be. Can you please advise.

[iira]

Thank you for the wonderful explanation, however I am getting error as "Missing relationship between these fields"

[katarinalabanova]

Hello, thanks for great tutorial! I want to ask if it is possible to put IF statement to field parameter formula?

[abduvosidmalikov]

thank you for the video

but I'm really curious what kind of keyboard you use ...