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:
Go to the Modeling tab and select New parameter > Fields.
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.
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.
Conclusions
You've just witnessed the transformative power of Dynamic Slicer in unlocking valuable insights and driving data-driven decision-making. But maximizing the full potential of Power BI requires more than just understanding its features – it demands a strategic implementation tailored to your unique business needs.
From expert data modeling and top-notch report development to crafting dynamic dashboards and empowering user training sessions, BI Solusi are here to provide you with end-to-end solutions that not only meet but exceed your expectations. Dive deeper into the world of Power BI Implementation by clicking the button below, and let's embark on this exciting journey together!
#PowerBI #DataVisualization #BusinessIntelligence #DynamicSlicer #DataAnalysis #Analytics #Reporting #DataInsights
BI Solusi is your trusted partner for data-driven success in Indonesia, serving companies in the Southeast Asia region and beyond. We specialize in implementing cutting-edge Data Analytics, Business Intelligence platform, and Big Data solution, complemented by expert Data Science services.
We offer flexible nearshore and offshore BI implementation models to meet your specific needs and deliver the highest-quality results.
Our BI Consulting expertise encompasses Data Integration services (ETL), Data Warehousing, and the utilization of Data Visualization tools such as Microsoft Power BI, Qlik Sense, and Tableau for Reports and Dashboards implementation.
Let us help you unlock the full potential of your data and achieve your business goals.
Thank you for this highly informative article. I appreciate the efforts.