top of page

Dynamic Slicer Using Field Parameter - Power BI

Updated: Feb 22

We know that a lot of Data Analysts or BI Analysts want to build an interactive experience for their end users. Dynamic slicer allows end-users to control the fields used in other slicers with the click of a button and change what measures or dimensions are being used across multiple visuals within the entire report.

Now, Power BI can make dynamic slicer by using a brand-new public preview feature called Field Parameters. This new feature allows a dynamic scenario, so that end users can really customize what they're analyzing based on what their needs are. The end-users can dynamically change the measures and dimensions being analyzed within a report.

For example, there is an employee data, we want to make a visual using bar chart to show average of annual salary by City, Country, Department, and Job Title. We must first make four visual bar charts for each average of annual salary by City, Country, Department, and Job Title. But in this case, we just want to show one visual bar chart, so there are a lot of space to use for other visual. We can use field parameter by creating a new dimension parameter (we will call it “Parameter”), inputting City, Country, Department, and Job Title as a new parameter, and then create new slicer with “Parameter” as its value. Now end-user can dynamically change the value of the bar chart visual with the value they want to see.

Change from Average of Annual Salary by City to Job Title

To create a Field Parameter:

  1. Go to the Modeling tab and select New parameter > Fields.

  2. Then build the parameter, provide a name for the parameter and select the fields you want to use. In this example, see the selected dimensions City, Country, Department, and Job Title.

  3. Then press Create to automatically create a new dynamic slicer.

Furthermore, we can provide end-users with the ability to filter the value in the visual to match the value that they want to see. For example, for the Average of Annual by Job Title, there are a lot of job titles that makes the visual hard to see, we want the end-users to dynamically choose the value in Job Title that they only want to see, such as the average of annual salary of Analyst, Automation Engineer, and Business Partner.

To do that, we make a can just duplicate the dynamic slicer that we make. In the Values or Field box, select the down arrow next to the parameter name or right click it, then select Show values of selected field. Now the end-user can freely change the value that they want to see. We will call this slicer “Parameter Value”.

Change from All value in Job Title to Analyst, Automation Engineer, and Business Partner in Job Title

The difference between this slicer and the normal slicer is that we don’t have to create 4 slicers (City, Country, Department, and Job Title) to filter the value; we can just click the other parameter in the “Parameter” slicer that we make, and then the “Parameter Value” slicer will change according to the value of “Parameter” that the end-user chooses.

You can see more details about Field Parameter in this link.

Need assistance with your PowerBI implementation? Contact us today!

#PowerBI #DataVisualization #BusinessIntelligence #DynamicSlicer #DataAnalysis #Analytics #Reporting #DataInsights

1,613 views0 comments

Recent Posts

See All
bottom of page