FILTERS AND SLICERS

ADVANCED POWER BI FEATURES FILTERS AND SLICERS FOR TRAINING

This tutorial will teach you how to use filters and slicers in Power Bi. The Filter is a significant feature in Power Bi that can help you in many ways and can make your work easier. Before we go into the depth of this feature, let us first create a visual.

Connect the excel file used in the previous tutorial and create a stacked area chart. Expand a few levels to make it look more informative.

Filters and Slicers: Advanced Feature | Power Bi Training - PST Analytics

You already know how to work with colors and formatting. Change the color of your chart according to your needs.

Filters and Slicers: Advanced Feature | Power Bi Training - PST Analytics

This looks pretty neat. Let us learn something about highlighting in Power Bi. Notice that on the top left of your chart, there is a legend. Click on Men.

Filters and Slicers: Advanced Feature | Power Bi Training - PST Analytics

Clicking on Men highlights the curve representing the number of unemployed men. Now do the same for Women.

Filters and Slicers: Advanced Feature | Power Bi Training - PST Analytics

Highlighting is a useful feature in Power Bi.

Now, let us talk about the filters. When we highlighted the curve representing the number of unemployed men, the curve faded. When we use a filter, all the other curves do not just decay, they disappear.

The location of the Filters section is on the right-hand side of the main page. You will find various tabs under the section where each of them represents a parameter. Expand the drop-down menu for Age.

FILTERS AND SLICERS

Let’s take into account the age group 16-19 and reject the rest. Click on the checkbox against 16-19.

FILTERS AND SLICERS

The Filters separate the section you want to see and then display it on the chart.

There is another easy way to use a particular filter again and again. Instead of going to the Filters tab and selecting checkboxes, we can create a small visual known as Slicer. Go to the Visualizations section and click on Slicer. A little empty visual will then appear on the screen.

FILTERS AND SLICERS

Go to the Fields section, drag the Gender tab, and drop it inside the empty visual. Two checkboxes representing the two genders will appear. Clicking on either one of them will filter out the other one.

Filters and Slicers: Advanced Feature | Power Bi Training - PST Analytics

Filtering is a handy feature in Power Bi which one can get training for. To make your chart more specific and neat, you can use the Filters.

To learn more about these features, you need to practice and explore on your own. Add datasets and work on them. Play around with different visuals.

So, in the next tutorial, we will look at more advanced features of Power Bi.

Leave a Reply

Your email address will not be published. Required fields are marked *