PowerBI Report Filter using Slicer Visualization

In this Power BI article, we will discuss how to filter a report using Slicer Visualization in Power BI.

I have taken one example where I have a SharePoint list having Mall Name, Rating, Mall address and Number of Stores. Using Power BI I want to filter the Mall Name based on the address and rating.

First I have created a SharePoint list named “BangoreBiggestMall”. The SharePoint list has Title(default), MallName, Address, Rating, and NumberOfStores.

power bi slicer page filter
power bi slicer page filter

PowerBI Report Filter using Slicer Visualization

Open the Power BI desktop from the local system. Click on Get Data->More.

slicer visualization in power bi
slicer visualization in power bi

In the GetData page select the Online Services and click on SharePoint Online List. Click on Connect.

power bi slicer page filter
power bi slicer page filter

Pass the SharePoint site URL inside the input text box. Click on OK.

slicer visualization in power bi
slicer visualization in power bi

Choose the SharePoint site list name in the Navigator Page. In the right side, we can see all the columns name respective of the list name. Click on Load.

power bi slicer page filter
power bi slicer page filter

In the PowerBI Data tab, we will get all the columns of SharePoint list. Delete the unwanted column.

To delete the column just right click on the column name and we will get the delete option. I have deleted all the unwanted column in the below screenshot.

slicer visualization in power bi
slicer visualization in power bi

Now we are going to develop our report in the report tab. Go to the Modelling tab and select the columns and change the Data type to the whole number.

After changing the data type a sigma symbol will come before the column name.

power bi slicer page filter
power bi slicer page filter

In the PowerBi desktop report tab, click on the Stacked bar chart from the visualization option.

In the Axis field drag and drop the columns name which you want to display in the Axis. Value fields I have drag and drop the NumberOfStoresField.

When we have drag and drop two fields it is automatically added to the visual level filters field. Using the Power BI Stacked bar chart visualization I have to display the Mall name and number of stores present inside the mall.

power bi slicer page filter
power bi slicer page filter

Below screen short representing the same mall name and number of stores present inside a mall using Stacked Column Chart. In the Axis, I have added mall name and in the number of the value of stores name.

power bi slicer page filter
power bi slicer page filter

Using the Power BI PieChart Visualization I have shown the number of the store by mall name. In the Legend fields I have added the “Mall name” and in the values field “Number of stores”.

slicer visualization in power bi
slicer visualization in power bi

I have added one more visualization named as a stacked area chart. In that visualization, I have displayed the Mall name and “NumberOfStores”.

power bi slicer page filter
power bi slicer page filter

PowerBI Slicer Visualization

Now we will add the filter visualization. For Filtering the other visualization Power BI provides a Slicer visualization.

I have added the Slicer visualization from the Visualizations list. In the “Filed” text box I have added the Address column. So automatically the column is added in the Visual Level filters.

slicer visualization in power bi
slicer visualization in power bi

We can change the slicer orientation vertical to horizontal. So to change the orientation click on the Format tab. Expand the General option. Change the orientation vertical to horizontal.

power bi slicer page filter 7
power bi slicer page filter

For rating, I have added one more slicer visualization. Set the fields text box to Rating column.

slicer visualization in power bi
slicer visualization in power bi

Now I have added a card to display total stores available in all the Mall. I have added a Card Visualization. Set its fields text box to NumberOfStores.

power bi card visualization
power bi card visualization

I have added Table visualization to display all the columns.

power bi slicer page filter
power bi slicer page filter

In the Power BI page when we have selected the “Marathalli” and 5 ratings all the visualization value changed.

In all the visualization two malls are displaying. Card visualization total stores are displaying.

slicer visualization in power bi
slicer visualization in power bi

When we have selected the “Mahadevpura” all the visualization value is changed.

power bi slicer page filter
power bi slicer page filter

To Publish the report Click on “Publish”. But remember before Publish the application we need to save in our local system.

power bi slicer page filter
power bi slicer page filter

Now the below screen will come, click on “My workspace” and then select.

power bi slicer page filter
power bi slicer page filter

After Publishing successfully we will get the below screenshot.

power bi slicer page filter
power bi slicer page filter

You may like following Power BI tutorials:

In the Power BI blog, we were discussed how to filter a report using the slicer visualization and how to publish to the workspace in Power BI.

>