Step-by-Step Guide to Create a Slicer for Text in Power BI

1. Open Power BI Desktop:

Launch Power BI Desktop on your computer.

2. Load Your Data:

Click on Home > Get Data.

Choose your data source (e.g., Excel, SQL Server, etc.) and load your data into Power BI.

3. Select the Data for the Slicer:

In the "Data Pane", select the data fields you want to visualize. For example, you might choose Category.

4. Insert a Slicer:

Go to the "Build" pane on the right side.

Click on the "Slicer" icon.

5. Configure the Slicer:

Drag the desired fields to the appropriate areas in the Build pane

6. Customize the Card:

Use the "Format" pane to customize the appearance of your chart. You can change colors, add data labels, adjust axis titles, and more.

7. Save Your Report:

Once you're satisfied with your chart, save your report by clicking on File > Save As.

Example

Load the Sales Data:

Import your sales data into Power BI.

Create the Slicer:

Select the "Slicer" from the "Build" pane.

Add Fields:

Drag the "Category" field to the "Field" 

Customize:

Use the "Format" pane to adjust the chart's appearance.

By following these steps, you should be able to create a "Slicer" in Power BI that effectively visualizes your data

Try Following Formatting Options

1. Prepare a table below slicer with columns - subcategory and sales

Go to "Build" pane - select "Table" visual - drag "Subcategory" to "Columns" - drag "Sales" to "Columns" - now try selecting different categories in the slicer - the table shows data as per the category selected in the slicer - to clear the selection of slicer, click on the small "Eraser / Clear selection" icon in the slicer

2. Create hierarchies in slicers 

Drag the "Category" field to the "Fields" - drag "Subcategory" to "Fields" - now a hierarchy with subcategories will be created under category - click on a small down arrow (dropdown) to view hierarchy - click any subcategory and you will see the values change in table below    

3. Create slicer with state and cities showing sales according to subcategories  

Go to "Build" pane - select "Table" visual - drag "Subcategory" to "Columns" - drag "Sales" to "Columns" - you will get a table with subcategories and sales - go to "Build" pane - select "Slicer" - drag the "State" field to the "Fields" - drag "Cities" to "Fields" - you will get a slicer for states and cities - try to find out sales for different cities by clicking in the slicer