In this Power BI Tutorial, we will learn about Power BI Slicer buttons. Also, we will discuss the below topics:
- Power BI Slicer buttons
- Power BI Slicer Apply button
- Power BI Slicer button color
- Power BI Slicer button size
- Power BI Slicer button order
- Power BI Slicer radio button
- Power BI reset slicer buttons
- Power BI horizontal Slicer button color
When there are only a few options in a list, we can change the slicer from the list to the button.
This option is not automatic but we can convert the slicer list to a button by following some easy steps.
Create a slicer. For example, here we create a slicer like below:
Go to format section > General > Orientation > Horizontal.
In this way, we can convert the slicer button from the list. Also, this slicer is known as a Horizontal slicer. Each item of the slicer acts as a button. Later, we will see how to do more customization on the Power BI slicer.
In Power BI Slicer, we can add an Apply button to each slicer to apply changes when we are done.
To add an apply button, on Power BI Desktop > File tab > Options and settings > options > Current File > Query reduction.
After clicking on OK, an Apply button will appear on the slicer like below:
This is how to do add apply button on Power BI Slicer.
Here we will see how to customize the button color in Power BI Slicer.
Go to Format section > items
- Font color: We can change the font color of each item in Slicer.
- Background: It helps to change the background color of each item(button).
- Outline: It will give a outline to the each button.
- Text size: Here we can customize the text size of the each item in the Horizontal slicer.
- Font family: It helps to set the font style of the buttons.
Here is an example, by which we can customize the text color and background color on the Power BI Slicer button:
This is how to do power bi slicer button color.
From some research we get that, due to the size of the visual is fixed, the slicer buttons only can change their own size. It is not supported to lock them and resize the slicer automatically based on the button.
There is a fixed minimum size of the horizontal slicer. But we can reduce the size of the whole slicer to save spaces on the report.
We can change the order of the button in Power BI Slicer, ascending to descending or vice-versa.
If we take a textual field as data in a slicer, then it will be sort by alphabetically. Similarly, if we take a numerical field as data, then it will sort by number in ascending or descending order.
For example, here we create a slicer having a numerical field. Let’s follow the steps to sort the order.
Select the three dots(…) to get more options > sort ascending/sort descending.
By default, the data showing in ascending order. By selecting the ‘Sort descending‘ option we can change the bottom order like this:
Now we can see the numbers of buttons are arranged in descending order. We can see a yellow symbol(left side of sort descending) that indicates the option is being selected.
Let’s see how to create a radio button in the Power BI slicer.
Create a simple slicer like below:
Go to Format pane > Selection control > turn on single selection
In this way, we can do the power bi-slicer radio button.
Here we will see how to create a reset button in Power BI Slicer. For this we have to follow this step by step guide:
Create a simple Slicer. Here we take the slicer that we created previously.
Go to View tab > Bookmarks.
Here we add bookmarks and named as ‘Reset‘.
Then Go to insert tab > buttons > select Reset button.
Resize the button and place it over the slicer.
Go to view > selections. Then, select ctrl key + both button, slicer > right click > select Group > Group.
It will create a group on the selection pane. Give a proper naming conversion to the group.
Now select the Reset button > Format button > Action.
Now the reset button will work like this on slicer as well as on Power BI Report:
Now we will see how to set the button color in a simple Power BI Slicer, by following these simple steps:
Go to Formate Pane(the paint roller icon) > items
Not only the button’s color but also allows changing the font color, outline, text size, and font family.
This is how we can do the color buttons on the power bi slicer.
You may like the following Power BI tutorials:
- Power BI combine columns from two tables
- Power bi create a date table
- Power BI Clustered Column Chart
- Power BI Export Data
- Power BI Column Chart
- Power BI Date Hierarchy
From this above tutorial, we learned all about the Power BI Slicer button. Also, we discussed:
- How to convert simple slicer to Power BI Slicer button?
- How to customize the button color of Power BI Slicer?
- How to set the order on Power BI Slicer button?
- How to create radio button Power BI Slicer?
- How to create Power BI reset slicer buttons?
- How to set Power BI horizontal Slicer button color?
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