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.
PowerBI Report Filter using Slicer Visualization
Open the Power BI desktop from the local system. Click on Get Data->More.
In the GetData page select the Online Services and click on SharePoint Online List. Click on Connect.
Pass the SharePoint site URL inside the input text box. Click on OK.
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.
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.
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.
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.
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.
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”.
I have added one more visualization named as a stacked area chart. In that visualization, I have displayed the Mall name and “NumberOfStores”.
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.
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.
For rating, I have added one more slicer visualization. Set the fields text box to Rating column.
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.
I have added Table visualization to display all the columns.
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.
When we have selected the “Mahadevpura” all the visualization value is changed.
To Publish the report Click on “Publish”. But remember before Publish the application we need to save in our local system.
Now the below screen will come, click on “My workspace” and then select.
After Publishing successfully we will get the below screenshot.
You may like following Power BI tutorials:
- Create a Power BI report from Excel using Power BI Desktop
- Access to the resource is forbidden error in Power BI
- Power BI: Create a various report from SharePoint Online list
- Built-in Date Hierarchy in Power BI
- Power Bi relative date slicer
- Create a Power BI Dashboard and Add Reports to Power BI Dashboard
- Add Title, Image, and Video to Power BI Dashboard
- Power BI Visualizations examples
- Power BI Custom Visuals
- Microsoft Power BI Error: This content isn’t available
- Power BI On-premises Data Gateway
- Power BI Error: This content isn’t available
- Power BI Workbooks
- Power BI Buttons
- Enter Data into Power BI Desktop
- How to Split Columns in Power BI
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.
Hello Everyone!! I am Bhawana a SharePoint MVP and having about 10+ years of SharePoint experience as well as in .Net technologies. I have worked in all the versions of SharePoint from wss to Office 365. I have good exposure in Customization and Migration using Nintex, Metalogix tools. Now exploring more in SharePoint 2016 🙂 Hope here I can contribute and share my knowledge to the fullest. As I believe “There is no wealth like knowledge and no poverty like ignorance”