K2E Canada Inc
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG

Managing Slicer Filters in Power BI

6/1/2020

0 Comments

 
If you are working with Power BI, you probably already know how powerful Slicer filters are. The ability to add a Slicer and have it automatically filter everything on the report can be great! But, what about instances where you do not want the Slicer to filter all your tiles? Instead, you want the Slicer to filter only some of your tiles. How can you control your Slicers? Fortunately, as you will learn in this tip, managing Slicer filters in Power BI is exceptionally easy.

Limiting a Slicer's Reach

Consider the Power BI report shown in Figure 1. In this report, the “State” Slicer in the lower, right corner filters all six tiles by default. However, what if we wanted the Slicer to affect only the four tiles at the top of the report? What could we do to limit the Slicer’s reach?
Picture
Figure 1 - Sample Power BI Report With A Slicer
The answer is simple. Once you add a Slicer, click on the Slicer to select it. Next, click the Format tab on the Ribbon. Then, click Edit Interactions, and upon doing so, you will see that each tile on the report will have two icons appear in the upper, right corner. For each of the tiles you do not want to filter with the Slicer, click the icon on the right side labeled None. Doing so will disconnect the Slicer from that tile. Once you complete this process, click Edit Interactions again to apply your changes.

Summary

Slicers are great tools for filtering your Power BI-based reports and dashboards quickly, easily, and intuitively. However, you may not want your Slicer to affect all the tiles on a page. In these cases, as you have just learned, you can easily disconnect a Slicer from a tile using Power BI’s Edit Interactions feature.

If you want to give Power BI a try and have not yet downloaded the free Power BI Desktop application, visit https://www.powerbi.com. The application is free to all users.

See This tip in Action by Viewing the Video


Tommy Stephens

0 Comments

    Categories

    All
    Accountant
    Accounting Software
    Accounting Solutions
    Adobe
    Advisory
    AI
    Artificial Intelligence
    Automation
    Business Automation
    Business Intelligence
    Business Management
    Cloud Computing
    Collaborate
    Collaboration
    COVID 19
    COVID-19
    CPA
    CRM
    Customer Relationship Management
    Cybersecurity
    Dext
    Ecommerce
    Emerging Technologies
    Excel
    Forecasting
    Forecast Sheet
    Google
    Grammarly
    Internal Priorities
    KPIs
    LET
    Management Reports
    Microsoft 365
    Microsoft Teams
    Office
    Office 365
    Online Shop
    Outsourcing
    PivotTables
    Power BI
    PowerPoint
    Productivity
    QuickBooks
    Quickbooks Online
    Ransomware
    Receipt Bank
    Remote Work
    Security
    Small Business
    Small Business Accounting
    Small Business Accounting Software
    Stockhistory
    Technology
    Tech Update
    Windows
    Windows 10
    Word
    Work At Home
    Work From Home
    Zoho
    Zoho CRM

    Authors


    Ward Blatch
    Ward provides consulting and training services as the Managing Director of K2E Canada Inc. He joined K2E Canada in 2005 and is responsible for the Canadian operations of this international consulting group, which provides professional development technology education for accountants across Canada and the US. Ward lives in rural Nova Scotia and can be reached at ward@k2e.ca.

    Tommy Stephens
    Tommy is one of the shareholders in K2 Enterprises, affiliating with the Firm in 2003 and joining as a shareholder in 2017. At K2, Tommy focuses on creating and delivering content and is responsible for many of the Firm's management and marketing functions. Tommy resides in the metro Atlanta area. You may reach him at tommy@k2e.com.

    Randy Johnson
    Randy is a nationally recognized educator, consultant, and writer with over 40 years experience in Strategic Technology Planning, Accounting Software Selection, Paperless, Systems and Network Integration, Business Continuity and Disaster Recovery Planning, Business Development and Management, Process Engineering and outsourced managed services. Randy can be reached at randy@k2e.com

    RSS Feed

Training & Education

Webinars
Upcoming Events
Road to Excellence Online Seminar
Seminars
Conferences
Instructors

Tech News

K2E Canada's Tech Update Newsletter

More

Privacy Policy
About
Contact

K2E Canada Inc.  |  591 Highway 221  |  North Kingston, NS Canada B0P 1R0  |  (902) 200-9207
© 2020 K2E Canada Inc. ALL RIGHTS RESERVED.