WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn Power BI » Slicers in Power BI

Slicers in Power BI

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What are Slicers in Power BI?

Slicers in power bi are very similar to what we use slicers in ms excel, slicers are used to filter out some specific data from a report, but these filters are visible in the data itself and using these slicers user can select any values they want to be displayed in the report.

Slicers in Excel are visual filters that enable us to see the summary only for the selected data sets. A slicer is an alternative way of filtering the data in the Power BI dashboard. With just a click of the button, we can filter the specific data easily.

Slicers-in-Power-BI

How to Add Slicers Filter in Power BI?

For example, look at the below image of the dashboard in Power BI.

Dashboard

The above dashboard has many visuals with a summary of the entire data.

To create this power bi dashboard, use the following excel data by downloading it.

You can download this Power BI Slicer Excel Template here – Power BI Slicer Excel Template

Example #1

Now, if you want to see sales, COGS, and profit value for any specific product, we have many options on this dashboard. By adding the Power BI Slicer option, we will create one.

  • From the “visualization” pane, click on the “Slicer” visual, and it appears on the dashboard page.

Power BI Slicer Visual

  • Now for the field pane of the slicer, visual drag and drop the “Product” column.

Visual (Add Field)

  • This should insert the product name to the slicer.

Slicer with Names

From this slicer, we can choose any of the products available, and the whole dashboard will show numbers only for the selected product.

Popular Course in this category
Sale
Power BI Training Certification
4.5 (521 ratings)
6 Online Courses | 29+ Hours | Verifiable Certificate of Completion | Lifetime Access
View Course
  • I will choose “LG” from the slicer and see its impact on the overall dashboard.

Slicers Power BI - Select LG Product

As you can see above, overall sales were showing “99.37 M” since we have selected only the “LG” product from the slicer. It is showing only “12.34 M,” and similarly, the rest of the visuals are showing values only for the selected product (LG).

Example #2 – Add Multiple Slicers

We can add more than one type of slicer to our Power BI dashboard. Now we have added a slicer for “Product” similarly, add a slicer for “City” as well.

Slicer Visual (City)

  • Now choose any one city and anyone product and see the magic with dashboard numbers. I have selected the city as “Bangalore” and the product as “Redmi.”

Slicer (Select Product & City)

  • Below is the dashboard for selected items.

Multiple Slicer Result

So, the overall total sale value for the city “Bangalore” for the product “Redmi” is “2.92 M”.

Power BI Slicers Formatting

Once the slicers are added, it is important to know how you play with your Power BI slicers. Below are some of them.

#1 – Select Multiple Items

In order to select multiple items from the Power BI slicer, you need to hold the Ctrl key and keep clicking on the values that you want to select.

Slicers Power BI - Select Multiple Items

  • You can also design the selection option under the format tab of a slicer. Go to format and click on “Selection controls.”

Slicers Power BI - Selection Control

#2 – Insert Underline for Each Value

If you want to show underline for each item in the slicer, then this can be done under the “Item” section from the “Format” tab. Select “Bottom Only” Option from the “Outline” to add underline.

Slicers Power BI - Add Border

From this section, you can also change the font color of each item in the slicer, font size, background color, font name, etc.

Slicers Power BI - Formatting

#3 – Show Drop Down Instead of List

If you don’t want to show a Power BI slicer in the selection list like the above and instead want to show a drop-down list, you can do this by clicking on the down arrow key of the slicer. This will show the option of “List” or “Dropdown.”

Slicers Power BI - List or Dropdown

Based on the selection you make, it will start to show the slicer accordingly. I have chosen “Drop Down,” and my power bi slicer looks like this now.

Slicers Power BI - Drop Down Slicer

#4 – Change Orientation

One more thing you can do to fit in your slicer is you can change the “Orientation” of the slicer to either “Horizontal” or “Vertical.”

Slicers Power BI - Slicer Orientation

Since I have chosen “Horizontal” as the “Orientation” type, my slicer will look like this.

Slicer Horizontal Orientation

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

You can download this Power BI Slicer Template here – Power BI Slicer Template

Things to Remember

  • Slicers affect all the visuals in the dashboard.
  • Power BI slicers are very similar to pivot table slicers.
  • You can insert as many slicers as you want to be based on the data columns.
  • Power BI Slicers works like visual filters for visuals in the dashboard.

Recommended Articles

This has been a guide to Slicers in Power BI. Here we discuss how to add & format a slicer to filter the data in the Power BI dashboard with the help of examples and a downloadable template. You can learn more about Power BI from the following articles –

  • How to Share Reports in Power BI?
  • Power BI vs Tableau
  • Power BI Tooltip
  • Use Power BI Conditional Formatting
0 Shares
Share
Tweet
Share
Power BI Training Certification
  • 6 Online Courses
  • 29+ Hours
  • Verifiable Certificate of Completion
  • Lifetime Access
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Download Power BI Slicer Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download Power BI Slicer Excel Template

Special Offer - Power BI Training Certification (22+ Hours of Training) View More