How to create slicers in Power BI [EASY GUIDE]

Reading time icon 2 min. read


Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team. Read more

Creating slicers in Power BI is one of the most used functions of this tool, but sometimes, people are encountering an issue with this feature, as one user described:

I wanted to make the slicers look as a button that can be pressed. I tried following previous advice on here but I couldn’t find a Settings>General>Orientation option.

So, the OP didn’t find the Orientation option, which definitely makes work harder. Fortunately, there are quite a few solutions available.

Steps to create slicers in Power BI

1. Enable the header

  1. Go to Visualizations
  2. Enable Visual Headerpower bi visual header slicer

2. Change type

  1. Go to the upper-right area of the slicer.
  2. Change type as List.

This guide will help you become an expert in Power BI!


3. Select a slicer visual

  1. Select the slicer visual.
  2. Move the column that you have the names to filter.power bi slicer column
  3. Edit the properties of the slicer in General and change Orientation from vertical to horizontal.power bi slicer visual
  4. Go to Items and change the font and background of the bottoms.power bi slicer
  5. Modify the size of the slicer visual.

Conclusion

So, there are many ways to create slicers in Power BI, and each method is designed for the needs of each user. Also, these are easy steps that any beginner can understand.

Did you find these methods useful? How do you create slicers in Power BI? Let us know in the comments section below!

RELATED ARTICLES YOU NEED TO CHECK OUT:

User forum

0 messages