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.
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.
- This is useful if you need to share the filtered results without giving access to the entire report.
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.
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.
- Press Enter.
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-driven 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 you add text visual in Power BI?
In the Visualizations pane, select the Smart narrative icon. If you don’t see it, you may need to turn on the preview. Power BI creates a text box with autogenerated text describing interesting features of the data in your report. You can format it as you would any other text box.
How do you apply a slicer to a visual in Power BI?
Adding a Slicer in Power BI
- Open the appropriate Power BI report,
- Choose the chart or table you want to add the slicer to,
- Under the ‘Visualizations’ window, click ‘Slicer’,
- Drag the desired field from the ‘Fields’ window to the ‘Slicer’ window and into ‘Values’,
How do you preview text slicer in Power BI?
Enabling the Text Slicer Feature
- Click on the gear icon located at the bottom right corner of the screen.
- Select ‘Preview Features’ from the menu.
- Check the box next to ‘Text Slicer Visual’.
- Click ‘OK’ and restart Power BI Desktop.
What is a text slicer?
A text slicer in Power BI is a filtering control that lets users type free-form text to dynamically filter report data, rather than selecting from a predefined list of values. Unlike standard slicers that display checkboxes or dropdowns, the text slicer accepts typed input and filters visuals in real time based on string matches. This makes it especially useful when dealing with large datasets where scrolling through hundreds of categorical values would be impractical. For example, a user can type a customer name, product code, or keyword, and the report instantly narrows results to matching records. The text slicer supports partial matches, so entering the first few characters of a value is enough to filter the data. It is available through Power BI’s built-in slicer visual when configured with a text field, and also through custom visuals from AppSource designed specifically for text-based search filtering. Organizations working with high-cardinality columns like email addresses, descriptions, or transaction IDs benefit most from this approach, since dropdown or list slicers become inefficient at that scale.
What is the input slicer visual previously called text slicer?
The input slicer visual in Power BI was previously called the text slicer, a custom visual that allows users to filter report data by typing free-form text directly into a search field. Microsoft rebranded it as the input slicer in more recent versions of Power BI, though many users and documentation still refer to it by its original name. The visual works by letting report viewers enter a keyword or phrase, which then dynamically filters the dataset to show only rows where the selected field contains that text. This makes it especially useful for filtering large tables with string-based columns like product names, customer names, or transaction descriptions, where a standard dropdown or list slicer would be impractical. You can find the input slicer by searching for it in the Power BI visuals marketplace or importing it as a custom visual from AppSource. Once added to a report canvas, you connect it to a text-based column in your data model and configure match options such as contains, starts with, or exact match to control filtering behavior.
How to edit slicer text?
To edit slicer text in Power BI, select the slicer visual, then use the Format pane to modify text properties including font size, font family, font color, and text alignment under the Values or Selection controls section. For more specific edits, here is what you can adjust: Display text: The text shown in a slicer comes directly from your data field. To change it, you need to rename the column in Power Query Editor or create a calculated column with the desired labels using DAX. Font and styling: In the Format pane, expand the Values section to change font size, color, bold, italic, and background color for slicer items. Header text: Select the slicer, go to Format pane, enable the Slicer header toggle, and type a custom title in the Title text field to replace the default field name. Search box placeholder text: If the search option is enabled, the placeholder text is not directly editable in standard Power BI Desktop but can be influenced through custom visuals or report themes. If you need consistent text formatting across multiple slicers, applying a Power BI report theme with predefined typography settings is the most efficient approach. For text slicer visuals specifically, the input text a user types is controlled at runtime, so design-time edits focus primarily on placeholder styling, font settings, and header labels rather than dynamic content.
What is the purpose of a slicer?
A slicer in Power BI is an on-canvas filter that lets report viewers interactively narrow down data without opening a filter pane. Instead of applying filters behind the scenes, slicers give users direct, visible control over what data appears in charts, tables, and KPI cards on the same report page. The primary purpose is to make reports self-service friendly. A business analyst or executive can click a slicer value, such as a specific region, product category, or date range, and every connected visual updates instantly to reflect that selection. This reduces the need for multiple static report versions and keeps dashboards dynamic. Text slicers specifically work with string-based fields like customer names, department labels, or product descriptions. They support list, dropdown, and search-based selection modes, which is especially useful when a field contains dozens or hundreds of unique values. A dropdown or search-enabled text slicer keeps the report layout clean while still giving users precise filtering capability. From a data storytelling perspective, slicers also make reports more transparent. Users can see exactly which filters are active at any moment, which builds trust in the numbers being displayed. For organizations using Power BI as part of a broader data and analytics strategy, well-designed slicers are a simple but high-impact way to improve report usability and drive faster, more confident decisions.
What is a slicer visual?
A slicer visual in Power BI is an on-canvas filtering tool that lets report viewers interactively narrow down data without opening a filter pane. Unlike filters applied in the background, slicers appear directly on the report page as clickable controls, giving end users a visible, self-service way to segment data by categories, date ranges, numeric values, or text strings. When a user makes a selection in a slicer, every connected visual on the page updates instantly to reflect only the relevant data. This makes slicers one of the most practical tools for building interactive dashboards, since non-technical users can explore data independently without modifying the underlying report structure. The text slicer specifically filters data based on string values, such as product names, regions, employee names, or department codes. It typically renders as a dropdown list, a vertical list, or a search-enabled input field, depending on how the report developer configures it. For organizations managing large datasets with many categorical dimensions, text slicers reduce the time spent hunting for specific records and make reports far more usable across different audiences.
What are the 4 types of filters?
Power BI has four types of filters: visual-level filters, page-level filters, report-level filters, and drillthrough filters. Visual-level filters apply only to a single chart or visual on the canvas. Page-level filters affect every visual on a specific report page. Report-level filters apply across all pages in the entire report, making them useful for global data constraints like date ranges or regions. Drillthrough filters work differently they let users right-click a data point and navigate to a dedicated detail page that automatically filters to that specific context. While these filters work through the Filters pane, the text slicer visual serves a related but distinct purpose. It lets users type a keyword or phrase directly on the canvas to filter visuals interactively, which is more intuitive for end users than the Filters pane. Understanding all four filter types helps you decide when to use a slicer versus a background filter slicers are visible and user-controlled, while pane-based filters are often set by the report developer and hidden from casual users.
How to add text in slicer?
To add text in a Power BI slicer, connect the slicer visual to a field from your data model that contains text values, such as category names, product names, or region labels. Here are the steps to follow: Open your Power BI Desktop report and go to the report canvas. Click the slicer icon in the Visualizations pane to insert a slicer visual. In the Fields pane, find the text-based column you want to use. Drag that text field into the Field well of the slicer, or click the checkbox next to the field while the slicer is selected. The slicer will automatically populate with the text values from that column. If you want to display custom text labels, you can create a calculated column in DAX that formats or concatenates text values to your preference, then use that column as your slicer field. For a text slicer that functions as a search input, enabling the search bar within the slicer settings lets users type text to filter results dynamically. You can turn this on by selecting the slicer, clicking the three-dot menu, and choosing the search option. Using text-based slicers alongside numeric or date slicers gives report users more precise filtering control, which is especially useful in dashboards handling large or complex datasets.
How to use slicers?
Slicers in Power BI are filter controls placed directly on a report canvas that let users narrow down data without opening a separate filter pane. To use one, go to the Visualizations pane, select the slicer icon, then drag a field from your data model into the Field well. Power BI will render an interactive control that filters all related visuals on the page by default. For text-based slicers specifically, you can switch between list, dropdown, and tile styles by clicking the format options. Users can then click one or more values to filter the report in real time. To enable multi-select, hold Ctrl while clicking, or turn on the Multi-select with CTRL toggle in the slicer settings. A few practical tips to get more out of slicers: sync slicers across multiple report pages using the View menu’s Sync Slicers panel, use the search box within a list slicer when dealing with long value lists, and apply visual-level filters to control which other visuals a slicer affects. You can also set a default selection so the report loads in a filtered state by default. For teams building self-service analytics dashboards, well-configured slicers reduce the need for multiple report versions by letting a single report serve different audience segments dynamically.
How to apply text filter?
To apply a text filter in Power BI, add the Text Slicer visual to your report canvas, then type your search term directly into the slicer’s input field. The visual will filter your data in real time, showing only records that match the text you enter. Here is the step-by-step process: first, import the Text Slicer from the Power BI AppSource if it is not already available in your visuals pane. Next, drag it onto your report canvas and bind it to the text column you want to filter, such as a product name or customer field. Once connected, typing any keyword into the slicer automatically cross-filters all other visuals on the page that share the same data source. You can also configure match options like contains, starts with, or exact match depending on how precise your filtering needs to be. This makes the Text Slicer particularly useful for large datasets where dropdown or list slicers become impractical. For teams building self-service analytics dashboards, this kind of dynamic text filtering reduces the need for multiple static filter panels and keeps reports clean and user-friendly.
How to properly use a slicer?
A slicer in Power BI works as an on-canvas filter that lets report viewers narrow down data without opening the filter pane. To use it properly, add a slicer visual to your report canvas, then drag the field you want to filter by into the Field well. For effective slicer usage, keep these practices in mind. Place slicers in a consistent location across report pages so users always know where to find them. Use the format pane to switch between dropdown, list, and tile style depending on how many values the field contains. For fields with many distinct values, dropdown style keeps the canvas clean. For fields with fewer options like regions or product categories, tile or list style improves usability. Sync slicers across multiple pages using the Sync Slicers panel under the View menu, so a selection on one page carries over to others. This is especially important in multi-page reports where users expect consistent filtering behavior. For text-based slicers specifically, the search box option lets users type partial matches instead of scrolling through long lists, which significantly speeds up filtering. You can enable this in the slicer header settings. Finally, set a default selection or use the clear button to reset slicers, preventing stale filters from affecting data views. Teams working with Power BI report design, including those following structured development practices like Kanerika, typically treat slicer placement and sync configuration as part of the core report layout planning process rather than an afterthought.
When to use slicer vs filter?
Use a slicer when you want end users to interactively control what data they see on a report page; use a filter when you want to restrict data silently in the background, often set by the report developer. Slicers are visible on the canvas, making them ideal for dashboards where business users need to explore data by selecting categories, date ranges, or text values without editing the report. They create a transparent, self-service experience. Filters, applied through the Filters pane, work better when you need to permanently exclude irrelevant data, apply report-level or page-level restrictions, or limit data without cluttering the visual layout. For example, filtering out test records or inactive accounts is typically a background task users should not override. A practical rule: if the selection changes frequently based on user needs, use a slicer. If the restriction is a fixed business rule, use a filter. Text slicers in particular add value when users need to search or match specific string values dynamically, which a static filter cannot support. Organizations building self-service analytics platforms, like those Kanerika helps design on Power BI, typically combine both, using filters to enforce data governance guardrails and slicers to give end users meaningful control over their analysis.
Why do we use slicers?
Slicers in Power BI are used to filter report data interactively, letting viewers narrow down visuals to specific values without editing the underlying query or report structure. Instead of applying static filters in the background, slicers give end users direct control over what data appears on screen, making reports more dynamic and self-service friendly. A text slicer specifically allows filtering by string-based fields like product names, regions, or customer categories, which is particularly useful when dropdown or list slicers become too long to navigate comfortably. Users can type a partial value and instantly filter all connected visuals on the page. From a practical standpoint, slicers reduce the need for multiple static report pages, since one well-designed page with the right slicers can serve many different filtering scenarios. This keeps reports leaner and easier to maintain. For organizations building data products at scale, applying slicers consistently across reports also supports a cleaner, more governed analytics experience, something Kanerika prioritizes when designing Power BI solutions for clients who need flexible yet governed self-service reporting.



