Power BI has become one of the most widely adopted data analytics platforms globally, with over 375,000 organizations leveraging its capabilities to transform data into actionable insights. Its user base spans across various industries, from multinational corporations to small businesses, all utilizing Power BI to enhance decision-making and operational efficiency.
What sets Power BI apart is its regular updates and continuous feature enhancements. Every month, Microsoft rolls out new updates, improving everything from data connectors to visualization options. The November 2024 update is no exception, introducing a new feature that further boosts Power BI’s versatility and usability: the Text Slicer Visual.
This new feature allows users to filter large datasets by typing text directly into a slicer box, removing the need to scroll through long lists. It enables faster, more efficient data filtering , especially for those working with extensive datasets.
In this blog , we’ll explore how to enable the Text Slicer Visual, set it up in your reports, and integrate it with other visuals for a smoother and more intuitive filtering experience.
The Key Steps in Enabling the Text Slicer Visual in Power BI Before using the Text Slicer Visual, you must manually enable it inside Power BI. It is currently available as a Preview Feature, so it is turned off by default.
Here’s exactly how you can activate it:
1. Open Options Settings Launch your Power BI Desktop application. Go to the File menu at the top left corner. Choose Options and Settings, then select Options from the dropdown. 2. Enable Preview Feature A settings window will open. On the left-hand menu, scroll down and click on Preview features. Find the option called Text Slicer Visual. Check the box next to it to enable the feature. 3. Apply Changes Click OK to confirm your selection. If you enable it for the first time, you may need to restart Power BI or open a new file for the visual to appear.
Once enabled, the Text Slicer Visual will be inside your standard visualizations panel and ready to use in your reports.
Move Beyond Legacy Systems and Embrace Power BI for Better Insights Partner with Kanerika Today.
Book a Meeting
How the Text Slicer Works The Text Slicer Visual is simple but powerful. It allows users to type a keyword or a number directly into a slicer box and filter the data instantly based on that text.
Here’s how it works in a real report:
1. Add the Text Slicer Visual After enabling it, go to the Visualizations pane. Drag the Text Slicer visual onto your report canvas, just like you would add any other visual.
2. Connect a Field to the Slicer Select the Text Slicer visual. Drag a field from your data model (for example, Brand Name or Category) into the slicer’s field well. This field will now be searchable using text input.
3. Input Text to Filter Click inside the Text Slicer input box. Type any keyword, number, or partial value related to the field you linked. You can either press Enter or click the Apply button (small arrow) to trigger the filter.
Your report’s data will immediately narrow to show only the entries that match the text you typed. It’s fast and direct and removes the need to scroll through long lists of options.
A Simple Guide to Using the Text Slicer in a Real Report Now that the Text Slicer Visual has been added to your report let’s walk through a real example to see how it behaves with live data.
1. Create a Table Visual In your Power BI report view, click on the blank canvas. Add a Table visual from the Visualizations pane. Bring fields like Brand and related measures (for example, Net Sales ) into the table. 2. Add the Text Slicer Drag the Text Slicer Visual onto the same page. Link the Brand field to the Text Slicer. This makes your slicer ready to accept text input for filtering. 3. Test Different Text Inputs Click inside the Text Slicer’s input box. Type 1 and press Enter → The table will show all brands containing “1”. Change it to 11 and press Enter → the table filters further to only brands containing “11”. Type 10 and press the Apply arrow → you will see data related only to brand “10”.
What Are the Additional Text Slicer Options in Power BI? The Text Slicer Visual in Power BI has some extra options that make it even more flexible during report building and usage. These options are available through the small three-dot menu on the top right corner of the visual.
Here’s what you can do:
1. Export Data You can export the filtered data the Text Slicer shows into a separate file. 2. Show as Table The slicer data can be viewed in a simple table format. This makes it easier to read large amounts of slicer results directly. 3. Spotlight The Spotlight option allows you to highlight the Text Slicer during a presentation or when explaining a report. It dims the rest of the report page, focusing only on the Text Slicer. 4. Sort Ascending / Descending You can alphabetically sort the values inside the slicer in ascending or descending order. This helps when working with large fields like product names or categories. 5. Clear Selection The Clear button inside the slicer removes the current search input. After clearing, the slicer will show all available values again without any filters applied.
These small but important options give you more control over managing and displaying filtered data using Text Slicer Visual. Each time you type a new value and apply it, the data in the table instantly adjusts. This shows how fast and focused the new Text Slicer makes filtering inside your reports.
Creating Dependent Slicers Based on the Text Slicer One of the most powerful features of the Text Slicer is its ability to control other slicers on the page. As a result, this allows you to create dependent slicers that react to the values selected in the Text Slicer, thereby providing more dynamic and intuitive filtering.
1. Add Another Slicer After placing the Text Slicer on your report page, add another Slicer Visual from the Visualizations pane. For this example, let’s use a Brand List Slicer (but you can use any slicer, such as a category or region).
2. Set Up Interaction Now, we want the Text Slicer to filter the Brand List Slicer based on the text input. To do this, go to the Format tab at the top, then click on Edit Interactions. You’ll see small icons appear above each visual. The Text Slicer will automatically filter the Brand List Slicer, but you need to disable it for other visuals if you don’t want them affected.
3. Test the Interaction Type a value (like 1) into the Text Slicer and press Enter. The Brand List Slicer will now show only brands that contain “1”. You can use the Brand List Slicer to filter other visuals, but the Text Slicer will not affect other visuals unless you allow it to.
By controlling which visuals are impacted by the Text Slicer, you can create a more interactive and tailored experience for your users.
Demonstration: Dependent Slicer in Action Now that we’ve set up the dependent slicers let’s see how everything works together in practice . By creating interactions between the Text Slicer and other slicers, you can control what data is displayed across multiple visuals at once.
1. Filter with the Text Slicer Enter a value in the Text Slicer (e.g., type 2). Press Enter or click the Apply button. The Brand List Slicer will update, showing only the brands that contain the number “2”. 2. Select from the Brand List Slicer Now, select a brand from the updated Brand List Slicer (e.g., select “Brand 2”). Your other visuals (e.g., a table, chart, or map) will be updated based on this selection. The interaction between the Text Slicer and the Brand List Slicer allows you to filter down the results dynamically. 3. Test Other Interactions Try entering different values into the Text Slicer, like 3 or 11, and notice how it updates the Brand List Slicer each time. The key here is that the Text Slicer filters the Brand List Slicer, which in turn updates other visuals, making it easy to drill down into the data.
By using dependent slicers, you can create an intuitive filtering experience that lets users search for data and quickly view the most relevant information across multiple visuals.
Limitation: Only One Field at a Time While the Text Slicer Visual is powerful, there is one limitation to keep in mind: it only supports filtering on one field at a time. This means you can filter, for example, by brand or Category but not simultaneously within the same slicer.
What Does This Mean for Your Reports? If you drag multiple fields into the Text Slicer, only one will be active for filtering. For example, if you try adding both Brand and Category to the slicer, only one of them will be used for filtering at any given time.
Why This Happens?
The Text Slicer is designed to work with a single text field to keep the filtering process fast and efficient.
If you need to filter across multiple fields (e.g., Brand, Category, and Item), you would have to use workarounds like creating a combined column (explained in a later section).
This limitation is something to consider when planning how to use the Text Slicer effectively. However, it’s still a great tool for focused filtering on a single field and can be combined with other slicers to enhance the filtering experience .
How to Migrate from SSRS to Power BI: Enterprise Migration Roadmap Discover a structured approach to migrating from SSRS to Power BI, enhancing reporting, interactivity, and cloud scalability for enterprise analytics .
Learn More
Workaround: Using a Combined Column for Multi-Field Search Although the Text Slicer supports only one field at a time, you can create a workaround to search across multiple fields simultaneously. The trick is to create a combined column that concatenates values from different fields into one single field. This allows you to filter multiple fields at once using the Text Slicer.
Step 1: Create a New Combined Column
Go to the Data View in Power BI. Select the table you’re working with (e.g., Items). Click on the New Column from the ribbon at the top. In the formula bar, use a DAX formula to combine the values from multiple fields into one string.
For example:
This formula combines Brand, Category, and Item into one field, with a space separating each value.
Step 2: Use the Combined Column in the Text Slicer
Go back to the Report View. Drag the Combined column into the Text Slicer Visual. Now, when you type in the slicer, it will search across all three fields (Brand, Category, and Item) at once.
Step 3: Test the Combined Search
Try entering a value like 10 in the Text Slicer and press Enter. You’ll see results where “10” appears in any of the combined fields — whether it’s in the Brand name, Category, or Item name.
This workaround allows you to simulate multi-field searching, making the Text Slicer more flexible when dealing with complex data models. However, it’s important to note that this is still a manual approach, and Power BI does not yet directly support true multi-field filtering within the Text Slicer.
How to Use the Text Slicer Visual with a Combined Field Now that we’ve created a combined column, let’s see how it works in action. This method allows the Text Slicer to filter across multiple fields at once, giving you more control over the data displayed in your report.
Step 1: Filter Using the Combined Column In your Power BI report, go to the Text Slicer. Type a keyword (e.g., 10) into the slicer input box.
Step 2: View the Results The slicer now filters data based on the combined column. For example, if 10 appears in Brand, Category, or Item, it will appear in the results.
You can also test this with other values like Brand 2 or Category A, and the slicer will filter across all the combined fields. This demonstrates how you can create a more flexible search experience, even though Power BI currently supports only one field at a time in the Text Slicer.
Stay Ahead of the Competition with Kanerika’s Advanced Analytics Solutions Kanerika is a premier data and AI solutions company that helps businesses unlock the full potential of their data with cutting-edge analytics solutions. Our expertise enables organizations to extract fast, accurate, and actionable insights from their vast data estate, empowering smarter decision-making.
As a certified Microsoft Data and AI solutions partner, we leverage the power of Microsoft Fabric and Power BI to develop tailored analytics solutions that solve business challenges and optimize data operations for better efficiency, performance, and scalability.
Whether you need real-time insights, AI-drive n analytics, or advanced BI capabilities, Kanerika delivers customized solutions that drive growth and innovation. Our deep expertise in data engineering, visualization, and AI ensures that your business stays ahead in an increasingly data-driven world.
Partner with Kanerika today and transform your data into a strategic advantage for long-term success!
FAQs
How do I add a slicer to a Power BI visual? To add a slicer to a Power BI visual, select the slicer icon from the Visualizations pane, then drag a field from your data model into the slicer’s Field well. The slicer appears on your canvas and immediately connects to other visuals on the same page. You can resize and position it for optimal dashboard layout. For numeric or date fields, Power BI automatically suggests range slicers. Kanerika’s Power BI consultants design intuitive slicer configurations that enhance report usability—connect with us to optimize your dashboard experience.
What is the difference between a filter and a slicer in Power BI? A filter operates in the background through the Filters pane and remains hidden from report consumers, while a slicer is a visible, interactive visual element placed directly on the report canvas. Filters apply at visual, page, or report level without user interaction required. Slicers empower end users to dynamically segment data themselves, making them ideal for self-service analytics scenarios. Both reduce displayed data, but slicers offer transparency and engagement. Kanerika helps enterprises implement the right filtering strategy for each use case—reach out for a Power BI assessment.
How to link a slicer to a visual in Power BI? Slicers automatically link to all visuals on the same Power BI report page by default through cross-filtering. To control specific visual interactions, select the slicer, navigate to Format > Edit Interactions from the ribbon, then click the filter or none icon on each visual to define the relationship. This granular control prevents unintended filtering across unrelated charts. You can also sync slicers across multiple pages using the Sync Slicers pane for consistent navigation. Kanerika builds sophisticated slicer interaction patterns for enterprise dashboards—let us streamline your report architecture.
What is the input slicer visual (previously called text slicer)? The input slicer visual, formerly known as the text slicer, allows users to type free-form text values to filter Power BI reports dynamically. Unlike dropdown or list slicers, it accepts direct keyboard input, making it ideal for searching large categorical datasets like product codes or customer IDs. Microsoft rebranded this feature to input slicer to reflect its broader functionality beyond text-only scenarios. It supports partial matches and wildcards for flexible data exploration. Kanerika implements input slicer solutions that accelerate data discovery in complex enterprise environments—schedule a consultation today.
How to add a text slicer in Power BI? To add a text slicer in Power BI, first enable the preview feature under Options > Preview Features > Input slicer. Then insert a standard slicer visual and bind it to a text field from your data model. In the Format pane, change the slicer style to Input to enable free-text filtering. Users can then type values directly instead of selecting from a list. This approach works best for fields with high cardinality where dropdowns become unwieldy. Kanerika’s Power BI experts configure text slicers optimized for your specific data structures—contact us to get started.
What is a text slicer? A text slicer is a Power BI visual that enables users to filter report data by typing text values directly rather than selecting from predefined lists. It functions as a search box within your dashboard, instantly filtering connected visuals based on typed input. Text slicers excel when filtering high-cardinality fields like transaction IDs, email addresses, or product SKUs where traditional dropdown slicers become impractical. The visual supports partial matching for flexible searches. Now called the input slicer, it remains essential for text-based data exploration. Kanerika deploys text slicer solutions that enhance user search experiences—reach out for implementation support.
How to enable text search in Power BI slicer? Enable text search in a Power BI slicer by selecting the slicer visual, opening the Format pane, expanding Slicer Settings, and toggling on the Search option. This adds a search box above your slicer list, allowing users to type and filter available selections quickly. For true free-text input filtering, enable the Input slicer preview feature and configure the slicer style as Input. Search functionality dramatically improves usability when slicers contain hundreds of values. Kanerika configures searchable slicers that streamline user navigation across enterprise dashboards—talk to our team for a customized solution.
How to customize a slicer in Power BI? Customize a slicer in Power BI through the Format pane, where you control visual appearance and behavior. Adjust slicer header text, font size, colors, and background under Visual settings. Modify selection controls to enable single-select, multi-select, or select-all options. Change orientation between vertical and horizontal layouts. For dropdown slicers, configure the expanded or collapsed default state. Apply conditional formatting to highlight specific values. Numeric slicers offer range slider customizations including step intervals. Kanerika designs branded slicer experiences that align with your corporate visual standards—connect with us for professional dashboard design.
Can a visual filter a slicer in Power BI? Standard visuals cannot directly filter slicers in Power BI because slicers function as filter sources, not filter targets. However, you can achieve bidirectional filtering using the Edit Interactions feature combined with specific data model configurations. Creating a bidirectional relationship between tables enables cross-filtering behavior where clicking a chart element affects available slicer values. Alternatively, use bookmarks to simulate visual-to-slicer filtering experiences. This approach requires careful relationship management to avoid circular dependencies. Kanerika architects data models that support complex bidirectional filtering requirements—schedule a technical consultation to explore your options.
How to make slicers only affect certain visuals in Power BI? Make slicers affect only certain visuals by selecting the slicer and clicking Format > Edit Interactions in the ribbon. Each visual on the page displays filter icons—click the none icon on visuals you want excluded from that slicer’s influence. The filter icon indicates active filtering; none means no interaction. This selective filtering prevents irrelevant slicers from affecting unrelated dashboard sections, improving user experience in complex multi-purpose reports. Save your interaction settings as they persist with the report. Kanerika configures precise slicer interactions for multi-audience dashboards—reach out for a dashboard optimization assessment.
What are the two types of slicers in Power BI? Power BI offers two primary slicer types: list slicers and range slicers. List slicers display categorical values as dropdown menus, tile buttons, or vertical lists, ideal for text and categorical fields. Range slicers provide numeric sliders or date range selectors for continuous data filtering. Additionally, the newer input slicer (text slicer) enables free-form text entry for direct value filtering. Each type serves distinct analytical purposes based on your data characteristics and user interaction requirements. Kanerika recommends the optimal slicer mix for your reporting needs—contact us for expert Power BI guidance.
What are the disadvantages of slicers? Slicers consume valuable dashboard real estate, potentially crowding report layouts and reducing space for core visualizations. They can slow report performance when bound to high-cardinality columns with millions of unique values. Multiple slicers create complex interaction patterns that confuse users without proper guidance. Slicers also increase report file size and refresh times. Unlike filters, slicers cannot easily apply report-level filtering across all pages simultaneously. Excessive slicers fragment user focus and dilute analytical clarity. Kanerika balances slicer utility against these constraints to deliver performant, user-friendly dashboards—let us audit your current slicer strategy.
When to use slicer vs filter? Use slicers when end users need visible, interactive control over data segmentation directly on the report canvas. Slicers suit self-service scenarios where users explore data independently. Use filters when applying fixed criteria that users should not modify, such as security-based restrictions or default report contexts. Filters work better for report-level scope and complex multi-condition logic. Slicers excel for user engagement; filters excel for governance and performance. Combining both strategically creates powerful, controlled analytical experiences. Kanerika helps enterprises define the right slicer-filter balance for each reporting scenario—book a consultation today.
How to change slicer type in Power BI? Change slicer type in Power BI by selecting the slicer visual and accessing the Format pane. Under Slicer Settings, expand the Options section and choose from available styles including List, Dropdown, Tile, or Input (for text slicers). Date fields offer additional options like Between, Before, After, or Relative Date. Numeric fields support slider range options. The available types depend on your bound field’s data type—text fields offer different options than dates or numbers. Switching types instantly transforms the slicer’s appearance and interaction model. Kanerika configures optimal slicer types aligned with user workflows—reach out for dashboard design expertise.
What is the purpose of a slicer? A slicer enables report users to filter Power BI visualizations interactively without navigating separate filter menus. Its purpose is providing intuitive, visual data segmentation that empowers self-service analytics. Users click slicer values to instantly narrow displayed data across connected charts, tables, and cards. Slicers make filter selections transparent and easily reversible, improving exploration confidence. They transform static reports into dynamic analytical tools where users investigate specific segments independently. Effective slicers reduce time-to-insight by eliminating manual data manipulation. Kanerika designs purpose-driven slicer implementations that accelerate decision-making—contact us for a Power BI strategy session.
How do you preview text slicer in Power BI? Preview the text slicer in Power BI by enabling it under File > Options and Settings > Options > Preview Features, then checking the Input slicer checkbox. Restart Power BI Desktop to activate the feature. After enabling, insert a slicer visual, bind it to a text field, and select Input style in the Format pane under Slicer Settings. The text slicer preview allows testing free-form text filtering before Microsoft releases it as generally available. Preview features may change before final release. Kanerika stays current with Power BI preview capabilities to deliver cutting-edge solutions—talk to us about implementing new features.
How to add a text filter in Power BI? Add a text filter in Power BI by expanding the Filters pane and dragging a text field into Visual, Page, or Report filter sections. Set the filter type to Basic for dropdown selection or Advanced for conditional operators like Contains, Starts With, or Does Not Contain. For visible text filtering, use the input slicer (text slicer) visual which provides an on-canvas text box for direct user input. The Filters pane approach works better for developer-controlled restrictions, while text slicers serve interactive exploration needs. Kanerika implements comprehensive text filtering strategies across enterprise reports—schedule a consultation for tailored guidance.
What is a slicer visual? A slicer visual is an interactive Power BI component that filters other report visuals based on user selections. It appears directly on the report canvas as a clickable list, dropdown menu, tile buttons, slider, or text input field. Unlike hidden filters, slicer visuals provide transparent, user-driven data exploration where selections instantly propagate to connected charts and tables. Slicers support single-select, multi-select, and search functionality depending on configuration. They transform passive reports into interactive analytical applications that engage business users. Kanerika creates intuitive slicer visual experiences tailored to your audience—connect with our Power BI specialists today.
