Tips & Tricks: PowerBI Slicer Settings

This is the first of what I hope to be many quick and easy tips and tricks with various technologies I learn along the way.

I’ve been working my way through the free edX Analyzing and Visualizing Data with PowerBI Course  and I learnt something new about PowerBI Slicers (something I thought I was pretty familiar with already). The trainer described slicers as “on canvas visualization filters” which I thought was quite apt and he then showed how you can change them from being vertical to horizontal.

This is how I would typically have used a slicer:

Vertical Slicer.png

Slicer with the default vertical configuration

In the above, you can see the circled tick boxes and the default vertical configuration on the right hand side. By changing this to horizontal, the visual looks far more like a button than it does a check box:

Horizontal Slicer.png

The same slicer, this time with a horizontal configuration

Clearly, the second option takes up more space in the above example, however on some reports it would be far more likely to work visually as buttons rather than check boxes.

Reminder: to get in and change this you need to select the slicer on the canvas, go to the visualizations menu on the right and then click the paintbrush / rollerbrush and look under ‘General’ settings for this visualization.

Happy visualizing!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s