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:

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

Click on the type of the slicer > Dropdown

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

Read Power bi Date Difference

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

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

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

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

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

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

By default, the data are sorted in ascending order.

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

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

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:

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.

Step-2:

Then click on Select the type of slicer > Dropdown.

Then the chart will look like this:

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?