Power BI Slicer Dropdown

In this Power BI Tutorial, we will learn about Power BI Slicer Dropdown. Also, will discuss:

  • Power BI Slicer dropdown
  • Power BI Slicer dropdown search
  • Power BI Slicer dropdown default value
  • Power BI Slicer dropdown sort
  • Power BI Slicer dropdown color
  • Power BI Slicer date dropdown

Power BI Slicer dropdown

A dropdown list is a graphical control element consisting of a list of elements that allows the user to choose one value from the list.

A dropdown button consists of a button that when clicked displays a drop-down list of mutually exclusive items.

When a list of options is a long list that takes too much screen space and becomes hard work to use, we can change a tick list into a dropdown.

By default a Power BI Slicer appears like this:

Power BI Slicer
Power BI Slicer

We can convert the list item to a drop-down list by following this easy step:

Click on the type of the slicer > Dropdown

power bi slicer dropdown
power bi slicer dropdown

The dropdown list items will appear by expanding the dropdown symbol(down arrow).

Power BI Slicer dropdown search

A search option helps to find and filter the data, which we selected. We can add a search option in the Slicer dropdown of Power BI, by following these steps:

Select the slicer > click on three dots(…) for more options> Search

power bi slicer dropdown search
power bi slicer dropdown search

By clicking on the Search option, it will appear on the dropdown of the slicer like this:

power bi slicer dropdown search
power bi slicer dropdown search

This is how we can add a search option in the dropdown of Power BI Slicer.

Read Power bi slicer contains

Power BI Slicer dropdown default value

We can set a default value in the Power BI dropdown Slicer, to save our time. As it is set as a default value it will show the filtered data automatically on the Power BI Report page.

Go to Format pane(Paint roller icon) > Selection controlls > turn on Single select

power bi slicer dropdown default value
power bi slicer dropdown default value

Now we can see the list of items is visualized in a dropdown like this:

power bi slicer dropdown default value
power bi slicer dropdown default value

Here, when we choose any item, then it will show as the default value in a dropdown slicer.

power bi slicer dropdown default value
power bi slicer dropdown default value

This is how we can set a default value on the Power BI Slicer dropdown.

Power BI Slicer dropdown sort

In Power BI dropdown Slicer, it allows showing the data in descending order or ascending order.

If we take a numerical field as a value, then it will order as ascending or descending by number. Similarly, If we take a textual field as a value, then it will sort as ascending or descending order alphabetically.

For example, here we take a textual field in slicer(Product). For sorting the item in a slicer,

go to more option(…) > sort ascending/descending

power bi slicer dropdown sort
power bi slicer dropdown sort

By default, the data are sorted in ascending order.

power bi slicer dropdown sort
power bi slicer dropdown sort

So when we will select the sort descending, the data are visualized in descending order like below:

power bi slicer dropdown sort
power bi slicer dropdown sort

We can see the above data on Power BI Slicer are arranged in alphabetical order in descending order.

This is how we can do Power BI Slicer dropdown sort.

Power BI Slicer dropdown color

Now we will see how to customize the dropdown color in Power BI Slicer. For implementing this:

Go to Format pane > Items

Power BI Slicer Dropdown color
Power BI Slicer Dropdown color

Here we set colors in Font color, Background from the color chart(Click on the downward arrow). After customizing the color, the dropdown will look like this:

Power BI Slicer Dropdown color
Power BI Slicer Dropdown color

This is how to do Power BI Slicer Dropdown color.

Power BI Slicer date dropdown

In Power BI Slicer, we can use the date field as a dropdown. It helps to find out the report of the particular selected date.

There is a step-by-step guide that shows us how to use the date field in the Power BI Slicer dropdown.

Step-1:

Create a Power BI Slicer, having a date field.

Power BI Slicer date Dropdown
Power BI Slicer date Dropdown

Step-2:

Then click on Select the type of slicer > Dropdown.

Power BI Slicer date Dropdown
Power BI Slicer date Dropdown

Then the chart will look like this:

Power BI Slicer date Dropdown
Power BI Slicer date Dropdown

This is how to do Power BI Slicer date Dropdown.

Conclusion:

Fro this Power BI Slicer tutorial, we learned about:

  • How to convert from Power BI Slicer list to dropdown?
  • How to add search option in Power BI dropdown slicer?
  • How to set default value in Power BI dropdown Slicer?
  • How to do sort order in dropdown list of Power BI Slicer?
  • How to customize color in Power BI Slicer dropdown?
  • How to use date dropdown in Powert BI Slicer?

>