Power BI Blog: Creating Dynamic Slicers using Field Parameters

Welcome back to
this week’s edition of the Power BI blog series.  This week, we look at how to create dynamic
slicers using field parameters.

Recently, Microsoft
released a public Preview of field parameters, which allowed end-users to
dynamically change the measures and dimensions being analysed within a report.  The initial release supported scenarios where Slicers
or Filter cards could control which fields would be used in different visuals:

However, it did not
support the ability for slicers to control the fields used in other slicers,
also referred to as dynamic slicers. 
Microsoft has now removed this limitation, and you can now parameterise
your slicers to support your dynamic filtering scenarios.  

For example, in the
report below we have three slicers: a measure picker, a dimension picker, and a
dynamic slicer for filtering values.  When
you change the selected field for the dimension picker, not only will the main
visual update but also the dynamic slicer will update as well to show the
values of the selected dimension, which may be used for filtering.

Microsoft has now
enabled the field parameters Preview feature by default, so you do not have to
manually turn on the Preview feature in the options menu.  To create a dynamic slicer using field
parameter, you will need to start by adding a field parameter to a slicer.  This is the slicer that we will use as the
field / dimension picker for the dynamic slicer:

Next, you might
want to duplicate the slicer using copy and paste.  This slicer will become the dynamic slicer
used for filtering values:

With the second
slicer selected, you may launch the field input context menu (right-click menu)
and select ‘Show values of the selected field’:

Now you have a
dynamic slicer!

In the meantime,
please remember we offer training in Power BI which you can find out more about here.  If
you wish to catch up on past articles, you can find all of our past Power BI
blogs here.