EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials Power BI learn Slicers in Power BI

Slicers in Power BI

Priya Pedamkar
Article byPriya Pedamkar

Updated March 28, 2023

Slicers In Power BI

What are Power BI Slicers?

Slicers are the coolest way to connect different tables and charts and filter them just by clicking. Putting the filters in any table will only filter the table there in that table. But filters cannot be used to filter the data in any chart or graph. For that we have Slicers. Most of the people have already seen or used Slicers in Excel. But even if you did not then also this article will help you to understand the Slicer in Power BI a lot. With the help of Slicer, we can filter any connected table, chart or matrix just by only clicking.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

How to Add Slicers in Power BI?

Slicers in Power BI is at the easiest place to access. We can access the Slicer from the visualization section by clicking on the icon. And this is available as shown below.

Slicers In Power BI Example 1

Once we click on it, we will be able to see the preview blank slicer as shown below.

Slicers In Power BI Example 2

After selecting the Slicer from visualization, we will see, Slicer has only one field that to be added which is Field. We can use Drillthroguh as well if we want to filter further in the same direction. Now drag the fields which want to see in Slicer directly in the section which is highlighted below.

Example 3 (Field)

Let’s go through a step-by-step procedure and Add Slicers in Power BI. The steps in detail are as follows:

You can download this Slicer In Power BI Excel Template here – Slicer In Power BI Excel Template
  • If you want to see how slicer works, for that first create a Dashboard which consists of different types of charts and table in Power BI. Here we have sales data of electronics products such as Mobile, Laptops, Desktops and Tablets as shown below. Which we will use that to create a sample dashboard.

(Excel Data) Example 1

  • Load the dataset into Power BI. For that click on Get Data Menu under Home Tab. From the drop-down menu of Get Data, select appropriate data source type. In this case, it is Excel, so clicked on Excel as shown in the below screenshot.

Example 1 (Menu Ribbon)

  • From the drop-down menu of Get Data option, select the type of file source which we want to upload. Here, our data is in Excel format. Once we select the file, in the navigator window, it will ask us to select the sheet which we want to upload. It is because there might be more than 1 sheet with the data but the sheet we want to choose can be anything. After that, click on the Load button highlighted in yellow to load the data into Power BI.

Example3 (Navigator)

  • With the help of the above data, we have created a simple dashboard which consists of Tables, Cards, Donut Charts and Stacked Column Charts as shown below. Also, we have kept some space to slicers as well.

Dashboard Example 4

  • Now we will add a slicer into it. For this, follow the procedure as we learned above. Go to visualization and click on the Slicer icon as shown below.

Slicers In Power BI Example 5

  • Now there are some certain fields by filtering them we will see the complete summary of the data. Here, major fields are City Name, Product Type and Salesperson. If we add any of them into the slicer, we will be able to slice our data with any of the parameters that it has. Let’ add Product type first here in slicer fields.

Slicers In Power BI Example 6

  • This is how our first slicer will look like with the Product type data field.

Example 7(Product type)

  • To test this, we will select any of the product type. Let’ select Mobile. We will see, the complete dashboard got filtered with the data with respect to product type Mobile. We can see the total quantity, total price sale, the salespersons who sold Mobile with their quantities and city names as well.

Mobil Example 8

  • Let’s insert few more slicers in our dashboard. For this, follow the same procedure. Here we will create the slicers for Salesperson and City name.

Slicers In Power BI Example 9

  • Let’s try to filter data with Desktop for City Name Cochin and with salesperson Rosy.

Slicers In Power BI Example 10

  • We will see Rosy has sold 1996 quantities of total price worth 1 Million Rupees of product type Desktop in Cochin.

Slicers In Power BI Example 11

  • So that how it becomes easy to create a dashboard in Power BI and add N number of slicers in it without establishing the connection. Now let’s select any of the slicer which we have created and understand the options and functions available under them.

Slicers In Power BI Example 12

  • Under Format, we have other options as well. We will see only important options here only.

Example 13 (Format)

  • There is another useful option available in the format section which is Item. By this, we can change the color of background and Font as per our theme.

Slicers In Power BI Example 14

  • After that, we have Title, Background, Lock Aspects, Border and Visual Headers. We can turn ON and OFF any of the options from below screen as per our need and see the changes in our slicers. As the names say, all these allow us to activate that function in our dashboard slicers.

Slicers In Power BI Example 15

  • There is one more important thing to learn. When we click on any slicer, at the right top end we have drop down arrow. If we click on that, we will get a list as shown below. This list allow us to see the fields in Slicer as List or as Dropdown. Currently, we have List view in our slicer. Let’s select Dropdown here.

Slicers In Power BI Example 16

  • We will see, our view in Slicer will get changed to Dropdown. And if we click on the down arrow, we will be able to see the all the product types listed under that slicer.

Example (Dropdown)17

Note: Power BI Slicers file can also be downloaded from the link below and the final output can be viewed.

You can download this Slicers In Power BI Template here – Slicers In Power BI Template

Pros of Slicer in Power BI

  • It is way better than traditional slicer in Excel.
  • We don’t have to connect any slicer with any table or chart.
  • It is similar to the slicer we use in MS Excel.
  • We can even change the orientation of the slicer.

Things to Remember

  • Slicers in Power BI are visual filter that directly shows the difference when applied or selected.
  • There is no limit of inserting a number of slicers in Power BI.
  • Slicer means, cutting off the data which we do not require and project the data which we want to show.

Recommended Articles

This is a guide to Slicers In Power BI. Here we discuss how to Add & format Slicers in Power BI with an example and downloadable template. You may also look at the following articles to learn more –

  1. How to Use Filter Function in Power BI?
  2. How to Create Charts in Power BI?
  3. What is Bullet Chart in Power BI?
  4. Power BI Tooltips | Creating Report Page Tooltips
  5. Guide to Power BI Parameters
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
All in One Data Science Bundle2000+ Hour of HD Videos | 80 Learning Paths | 400+ Courses | Verifiable Certificate of Completion | Lifetime Access
Financial Analyst Masters Training Program2000+ Hours of HD Videos | 43 Learning Paths | 550+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Slicers In Power BI Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Slicers In Power BI Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more