How to Add a Dropdown Slicer in Power BI

In this Power BI tutorial, We will learn what is Dropdown Slicer in Power BI, How to add a dropdown slicer in Power BI, and the use of a Dropdown Slicer in Power BI.

Additionally, We will cover these topics below:

  • Power BI dropdown slicer with search
  • Power BI can’t change the slicer to dropdown

Power BI Dropdown Slicer

A Dropdown slicer in Power BI filters the power bi report information on visualizations using the dropdown list presented in the data table. For example, we can select any of the values presented in the dropdown list, it will display the filtered data in the Power Bi report visuals.

In the following, we will see how to add a dropdown slicer in Power Bi and also will see how to filter the data based on the dropdown slicer selection.

Add a dropdown slicer in Power BI

Let us see how we can add a dropdown slicer in the Power Bi report canvas in Power Bi.

In this example, I have used the sales table data, to filter the based on the dropdown slicer visual in Power Bi.

  • Open the Power Bi desktop, and load the data into it using the get data option. Once the data has been loaded, create a power bi visualization by selecting the data fields from the fields pane.
  • Now, Click on the slicer icon presented in the visualization pane, and in the slicer visual, drag and drop the Product Name field name from the field pane for which you filter it.
  • Expand the down arrow presented in the slicer visual and choose the dropdown option as shown below.
Add a dropdown slicer in Power BI
Add a dropdown slicer in Power BI
  • Expand the drop-down and select any product from the drop-down slicer visual.
  • In the below screenshot, you can see that the stacked column chart visually displays the data based on the drop-down slicer selection.
Add a dropdown slicer in Power BI example
Add a dropdown slicer in the Power BI example

This is how to use the dropdown slicer visual to filter the data value presented in the Power Bi report based on the selection.

See also  How to duplicate multiple columns using Power Query

Check Out: How to Add a Date Slicer in Power BI

Power BI slicer dropdown multiple selections

Let us see how we can select multiple selections in the dropdown slicer in Power Bi.

Yes, it is possible to select multiple options in the dropdown slicer in Power Bi.

  • Load the data into it using the get data option. Once the data has been loaded, create a power bi visualization by selecting the data fields from the fields pane.
  • Now, Click on the slicer icon presented in the visualization pane, and in the slicer visual, Expand the down arrow presented in the slicer visual and choose the dropdown option drag and drop the Product Name field name from the field pane for which you filter it.
Add a dropdown slicer in Power BI
slicer dropdown multiple selections
  • To select multiple selections, click on the Ctrl key from the Keys and select the dropdown slicer selections.
  • In the below screenshot, you can see that the multiple options selected in the drop-down visual values are displayed in the stacked column chart.
Power bi slicer dropdown multiple selections example
Power bi slicer dropdown multiple selections example

This is how we can select multiple selections in the dropdown slicer in Power Bi.

Also Read: Power BI DAX Count [15 real examples]

Power BI dropdown slicer with search

Let us see how we can activate the search bar in the drop-down slicer in Power Bi,

There are two ways that we can activate the search bar in the dropdown slicer,

First way:

  • Load the data into it using the get data option. Once the data has been loaded, create a power bi visualization by selecting the data fields from the fields pane.
  • Now, Click on the slicer icon presented in the visualization pane, and in the slicer visual, drag and drop the Product Name field name from the field pane for which you filter it.
  • Select the ellipses presented in the drop-down slicer and click on the Search option like below:
Power Bi dropdown slicer with search
Power Bi dropdown slicer with search
  • In the below screenshot, you can see that the search bar has been added to the dropdown slicer in Power Bi.
Power Bi dropdown slicer with search example
Power Bi dropdown slicer with search example

This is one way to add the search bar in the dropdown slicer in Power Bi.

See also  Power BI DAX Min Date

Second way:

  • Load the data into it using the get data option. Once the data has been loaded, create a power bi visualization by selecting the data fields from the fields pane.
  • To add another search bar, click on the Ctrl +F key from the Keys and you can see that the search bar has been added to the Power Bi dropdown slicer.
Example of Power Bi dropdown slicer with search
Example of Power Bi dropdown slicer with search

This is another way to add the search bar in the dropdown slicer in Power Bi.

These are the two ways that we can activate the search bar in the drop-down slicer in Power Bi.

Have a look: Power BI Dax Min Filter [With 13 Examples]

Power BI can’t change the slicer to dropdown

  • No, it is possible to change the slicer to a dropdown slicer in Power Bi.
  • By default, when we add the Slicer visual to the Power Bi report it displays the list slicer.
  • Expanding the down arrow presented in the slicer we can see two options, They are list and dropdown.
  • Select the dropdown option as shown below, so that it will change from the list slicer to the dropdown slicer.
Add a dropdown slicer in Power BI
Add a dropdown slicer in Power BI

This is how to change the slicer to a dropdown slicer in Power Bi.

Additionally, you may like some more Power BI tutorials:

In this Power BI tutorial, We learned what is Dropdown Slicer in Power BI, How to add a Dropdown slicer in Power BI, and what is the use of a Dropdown Slicer in Power BI.

See also  How to Use Power BI Weekday Function?

Additionally, We covered these topics below:

  • Power BI dropdown slicer with search
  • Power BI can’t change the slicer to dropdown
>