Monday, July 30, 2018

How to add a SLICER to my report in Power BI?

SLICER control provides filtering capability to the report, both Basic and Advanced.

Here is a clustered column chart from one of my previous posts.
The data of Male/Female/Total populations for several states in India is shown.


This uses a Clustered Column chart shown.


The next image shows the data behind the above report.



Only very few of the Indian States haven been chosen for the report and if you had had all of the States in this view it will be more crowded. Now how do I just filter a State from this report. You can do this by adding a SLICER (shown in the next image and you find thiss under VISUALIZATIONS).




You click and add the SLICER. The SLICER gets added to the report as shown. Here is a List of all STATES in the report. Instead of a List , you could also opt for a Drop-down list.


Now using the Basic filtering you can manipulate the report to show the one for the STATE you choose in the LIST as shown (Herein PUNJAB is chosen).






In addition to Basic you also have Advanced filtering where you can impose further conditions on your choice for the states.

Using the condition that the STATE name starts with 'C', the number of States is reduced. Now you can choose from this reduced LIST.










No comments: