Power BI Slicer Buttons

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 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

Power BI Slicer buttons

When there are only a few options in a list, we can change the slicer from the list to button.

This option is not automatic but we can convert the slicer list to a button by following some easy steps.

Step-1:

Create a slicer. For example, here we create a slicer like below:

power bi slicer buttons
power bi slicer buttons

Step-2:

Go to format section > General > Orientation > Horizontal.

power bi slicer buttons
power bi slicer buttons

In this way, we can convert the slicer button from list. Also, this slicer is known as 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.

Read How to use Power bi ribbon chart

Power BI Horizontal Slicer button color

Here we will see how to customize the button color in Power BI Slicer.

Step-1:

Go to Format section > items

power bi Horizontal slicer button color
power bi Horizontal slicer button color
  • 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 Power BI Slicer button:

power bi Horizontal slicer button color
power bi Horizontal slicer button color

This is how to do power bi slicer button color.

Power BI Slicer button size

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.

Read Power BI Q&A – How to use with examples

Power BI Slicer button order

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 option > sort ascending/sort descending.

power bi slicer button order
power bi slicer button order

By default, the data showing as ascending order. By selecting the ‘Sort descending‘ option we can change the bottom order like this:

power bi slicer button order
power bi slicer button order

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.

Read Power BI Slicer Dropdown

Power BI Slicer radio button

Let’s see how to create a radio button in Power BI slicer.

Step-1:

Create a simple slicer like below:

power bi slicer radio button
power bi slicer radio button

Step-2:

Go to Format pane > Selection control > turn on single selection

power bi slicer radio button
power bi slicer radio button

In this way we can do the power bi slicer radio button.

Read Power BI Slicer – How to use with examples

Power BI reset slicer buttons

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:

Step-1:

Create a simple Slicer. Here we take the slicer that we created previously.

Step-2:

Go to View tab > Bookmarks.

Here we add a bookmarks and named as ‘Reset‘.

power bi reset slicer buttons
power bi reset slicer buttons

Step-3:

Then Go to insert tab > buttons > select Reset button.

Resize the button and place it over the slicer.

power bi reset slicer buttons
power bi reset slicer buttons

Step-4:

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.

power bi reset slicer buttons
power bi reset slicer buttons

Step-5:

Now select the Reset button > Format button > Action.

Reset buttons on Power BI Slicer
Reset buttons on Power BI Slicer

Step-6:

Now the reset button will work like this on slicer as well as on Power BI Report:

Reset buttons on Power BI Slicer
Reset buttons on Power BI Slicer

Power BI Slicer button color

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

power bi slicer button color
power bi slicer button color

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 power bi slicer.

You may like the following Power BI tutorials:

Conclusion

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?
>