Visualization of data is a key concept in Power BI.
This visualization can be achieved by representing the data in data models or by creating graphs or charts.
So, for creating and representing only the important data and hiding unnecessary data in charts or data models for data visualization we need creative forms called Slicers.
Power BI Slicers are the simple forms of filters that play a key role in designing customized charts and reports on the Microsoft Power BI Desktop.
In this Power BI Slicers Tutorial, you’ll learn:
- What is Power BI Slicer?
- Use of Power BI Slicers?
- How to Add a New Slicer?
- Types of Power BI Slicers
- Steps to Create a new Slicer to filter data by District Manager.
- Procedure for Creating a Slicer to filter data by Data Range.
- How can you Sync Slicers in Power BI and Use them on other pages?
- Power BI Slicers Limitations
Now, let us have a closer look at Slicers in Power BI.
What is Power BI Slicer?
Power BI Slicer is a canvas visual filter available in Power BI Desktop. Slicers in Power BI play the most crucial role in creating comparative charts or separate reports. Slicers act as an alternative solution in filtering the narrow portions of datasets that are represented in the form of other visualizations in a particular report.
Use of Power BI Slicers?
Power BI Slicers can be used in the below scenarios:
- To display important or commonly-used filters on the report canvas for easier access.
- To filter by columns to eliminate the hidden or unnecessary data in the tables.
- To design more creative reports by placing slicers next to important visuals.
- To show the currently applied filtered data without opening any filters or drop-down list.
Want to become a Data Visualization expert?
Then visit here to Learn Power BI Training Course from Mindmajix
How to Add a New Slicers in Power BI?
To add a Slicers in Power BI one must go through the following steps, and they are:
Step 1: Drag or select the data field first to create a visualization.
Step 2: Now, select the slicer icon present in the visualization pane to turn the visualization into a slicer.
What are the Different Types of Power BI Slicers?
The types of slicers in Power BI are listed below:
1. Relative Date Slicer
The date is the most important element at the time of business analysis because it helps us to identify the future forecast that how we are going to generate the revenue in the upcoming years.
There are four types of Power BI data slicers and they are:
In the Date Slicer "Between" provides the range of dates between the start and end date.
Subscribe to our youtube channel to get new updates..!
When we select the Before option in the Date Slicer, the start date automatically grades out, which means we can get the report before the end date.
When we click on the “After” in the date slicer pane the end date becomes stagnant so that we can fetch the results after the start date.
List in the Date Slicer provides a list of all the date ranges so that we can select dates accordingly for the results.
2. Numeric Range Slicer
The Numeric range slicer in Power BI is mainly used to apply all kinds of filter sorts to any numeric column in the data model. It even provides the most effective way to filter the data between numbers.
Steps to Create a New Slicer to Filter Data by District Manager
Step 1: In Power BI service or Power BI desktop, open the Retail Analysis Sample.
Step 2: Select the slicer icon present in the visualization pane to create a new slicer.
Step 3: Next, select the District>DM from the pane of fields to populate the slicer.
Step 4: New slicer is created with a list of names having selection boxes before them.
Step 5: Drag and resize the elements present on the canvas to make room for the slicer.
Step 6: Select the names that are present on the slicer and make a note of the effects on the other visualizations on the page. Selecting all the names will have the same effect and impact as selecting none.
How to Format a Slicer
To format your slicer, select the format icon and it displays all the formatting control options.
In the below example, the slicer that is present first has been converted to a dropdown in order to consume less space and then the option Select all has been added whereas the second slicer has been formatted with colors, font sizes, and allows only a single selection.
Procedure for Creating a Slicer to Filter Data by Date Range
Step 1: Firstly, without selecting anything on the canvas, just drop down the Store element from the pane of fields and then drag the OpenDate option to the values which are present in the visualization pane in order to create an effective visualization.
Step 2: Select the slicer icon to convert the new visualization to a slicer.
Step 3: Drag and resize the elements present on the canvas and the slicer to make room size space for the slicer. Just note that the slider always resizes with the slicer size.
Step 4: Using slider select different data ranges and keep an eye on effects on the other visualizations on the page.
Step 5: To change the slicer type, choose any one of the options from the box that you hover over the upper-right area of the slicer and make a note of the changes in slicer appearance.
Steps to Convert Vertical Slicer to a Horizontal Slicer
Step 1: With the selection of slicer, in the Visualization pane, now select the Format tab.
Step 2: Click on the General section for orientation and then select the horizontal option in it.
Upcoming Batches - Power BI Training!
6:30 AM IST
6:30 AM IST
7:00 AM IST
6:30 AM IST
Step 3: If you want to extend for more values, probably make the pane wider.
Step 4: Right under the orientation in the general section of the Format tab, slide responsive (preview) to on.
How can you Sync Slicers in Power BI and Use them on other Pages?
Step 1: Select the Sync slicers checkbox present in the view menu on Power BI Desktop.
Step 2: The pane of Sync slicers is present in between the Visualizations pane and Filters.
Step 3: Select District Manager slicer present on the District Monthly Sales page.
Step 4: Now, select the Overview page and the page of New Stores present in the Sync column in order to make sure that the District Monthly Sales slicer directly syncs to those particular pages.
Step 5: Next, select both Overview and New Stores pages in the Visible column. The below image shows the representation of the Sync Slicer.
Step 6: In this step, the District Manager slicer present on the District Monthly Sales page shows the same selections as the one on the Overview page. On the page of New Stores, selections available in the Store Name Slicer are affected by the selections present in the District Manager slicer.
Power BI Slicers’ Limitations
- Slicers in Power BI doesn't support visual level filters.
- Input fields are not supported in Power BI Slicers.
- Slicers do not support Drilldown.
- Slicers in Power BI cannot be pinned to a dashboard.
You can use Slicers very efficiently in Power BI for filtering small portions of datasets. They also play a key role in representing the most significant data in the form of charts or graphs. The Power BI desktop can be made more colorful by applying different slicer effects.
Power BI Slicers are simple yet powerful. Use it wisely, and it can have a positive impact on data visualizations.
We hope that you now have a clear knowledge on slicers in Power BI.
Got any questions? Leave a comment below.
Images Source: Microsoft