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).
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.
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?
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com