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.
You already know how to work with colors and formatting. Change the color of your chart according to your needs.
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.
Clicking on Men highlights the curve representing the number of unemployed men. Now do the same for Women.
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.
Let’s take into account the age group 16-19 and reject the rest. Click on the checkbox against 16-19.
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.
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.
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.