How to Select Multiple Values in Power BI Slicer?

Do you know how to use one Power BI slicer with multiple selections? No worries!

This Power BI tutorial will help you to achieve it. I will tell you how to select multiple values in Power BI slicer with various examples.

Also, we will see Power BI slicer multi-select without ctrl, disable multiple selections in the slicer Power BI, and Power BI hierarchy slicer multiple selections.

Power BI Slicer Multiple Selections

In Power BI, a slicer is a visual element that allows users to filter data in a report. Multiple Selections in the context of a Power BI slicer means that users can choose more than one option simultaneously.

Example:

We have a slicer (Product) and select multiple options such as Amarilla, Montana, etc. Now, the Power BI table has been filtered based on the multiple selections of the slicer, as shown in the screenshot below.

How to Select Multiple Values in Power BI Slicer

How to Select Multiple Values in Power BI Slicer

Now, I will tell you how to create and use the Power BI slicer with Multiple selections in the Power BI Report.

In this example, I will use the SharePoint list (Financial Sample) data shown in the screenshot below.

Power BI slicer multiple selections

1. Open the Power BI Desktop and load data using the Get data option.

power bi slicer select multiple

2. Under the Visualization panel, select Slicer.

power bi slicer multi select

3. Drag and drop the Segment into the slicer Field.

power bi slicer multiple select

To help in filtering any data in the Slicer visual, I now want to add a Table visual. The Table visual will be updated to reflect the modifications.

4. Under the visualization panel, select Table Visual, then drag and drop Product, Units Sold, Sales Price, Sales, and Profit into the Columns field.

multi selection in power BI Slicer

5. Now, To select Multiple selections from the slicer visual, select the slicer visual -> Format your visual -> Visual -> Slicer settings -> Selections. Enable Multi-select with CTRL and Make sure the single select is disabled.

Example of Power-BI slicer multiple selection

6. To select multiple selections, click “Ctrl + click.” you want to apply a filter from the slicer selections.

Here, I select Enterprise and Midmarket from the slicer selection, and then you can see the table visual change accordingly.

slicer multiple selection power bi

In this way, you create and use the Power BI slicer with Multiple selections in Power BI Desktop.

Power BI Slicer Multi-Select Without Ctrl

I will tell you how to create a multi-select Power BI slicer without ctrl on the desktop.

1. Open the Power BI Desktop and load data, then under the visualization panel, select Slicer Visual.

power bi slicer multi select without Ctrl

2. Drag and drop the Product into the slicer Field.

power bi slicer multiple select without Ctrl

Now, I want to add a Table visual, which will help when I filter any values in the Slicer visual. The changes will be reflected in the Table visual.

3. Under the visualization panel, select Table Visual, then drag and drop Product, Units Sold, Sales Price, Sales, and Profit into the Columns field.

multi selection in power BI Slicer without ctrl

4. Now select the slicer visual -> Format your visual -> Visual -> Slicer settings -> Selections -> Turn off the Single selection and turn off the Multi-select with CTRL.

Power BI slicer multiple select without ctrl example

5. Now, we can select multiple values without using the ctrl key selection in the Power BI slicer.

Power BI slicer list select multiple example

In this way, you create and use the Power BI slicer with Multiple selections without ctrl in Power BI Desktop.

How to Disable Multiple Selections in Power BI Slicer

I will explain how to disable multiple selections in the Power BI slicer.

In the above example (Power BI Slicer Multi-Select without Ctrl), select the slicer visual -> Format your visual -> Visual -> Slicer settings -> Selections -> turn on the Single select.

How to Disable Multiple Selections in Power BI Slicer

Now, the slicer allows the selection of only a single value. Attempting to select multiple values is restricted.

Disable Multiple Selections in Power BI Slicer

In this process, you can disable multiple selections in Power BI Slicer.

Power BI Hierarchy Slicer Multiple Selections

Now, I will tell you how to create a Power BI hierarchy slicer with multiple selections in simple steps.

In this example, we will create a hierarchy slicer consisting of a Product Name and Segment. We will filter multiple data sets by making multiple selections within the hierarchy slicer.

1. Open Power BI Desktop, load the data using the ‘Get Data’ option, and you will be able to view the data in the Data panel.

Power BI hierarchy slicer multiple selection

2. Under the Visualizations panel, select Slicer and drag Product and Segment into the Slicer field.

hierarchy slicer dropdown in power bi

3. Under the visualization panel, select Table Visual, then drag and drop Product, Units Sold, Sales Price, Sales, and Profit into the Columns field.

Power BI hierarchy slicer dropdown

4. Select the values you want to filter from the hierarchy slicer selections.

Power BI Hierarchy Slicer Multiple Selections

In this way, you can Power BI Hierarchy Slicer Multiple Selections.

Conclusion

I hope you followed the above steps to create a Slicer with Multiple Selections in Power BI.

This tutorial covered Power BI Slicer Multiple Selections and Multi-Select without Ctrl, disabling multiple selections in Power BI Slicer, and Power BI Hierarchy Slicer Multiple Selections.

Additionally, you may like some more Power BI tutorials: