Use Of Slicer In Power BI And Its Integration In SharePoint Online

Power BI is a Microsoft tool which provides many types of Visual Reports such as Clustered Column Chart, Clustered Bar Chart, Pie Chart, Donut Chart, Gauge, R script Visual, Tree map, Filled Map, Waterfall Chart, Scatter Chart, Slicer and many more. Among these, I will be demonstrating a slicer which can be used to filter a tabular report and other reports.

Step 1

Click on Power BI Desktop tool which will open the following window.

Power BI

Power BI

Step 2

Click on "Get Data" option and the following window will appear.

Power BI

Power BI

Step 3

You can import the data from Excel, SharePoint, Folder, CSV file, Facebook, Oracle DB, and many more. Here, I am using an Excel sheet to import my data. Click on "Connect" button on the bottom right corner of the window pane. The below screen will appear.

Power BI

Step 4

Select the required sheet and click "Load".

Power BI

Step 5

It will load all the fields. Please refer to the below screenshot.

Power BI

Step 6

Choose the Slicer visualization and check the field you want to use as a slicer.

Power BI

Step 7

Similarly, you can choose any visualizations you like and can make formatting. I have used Clustered Column Chart and a table.

Power BI

Step 8

After creating the report, save it with a proper name. You can share it from the top right corner with "Publish It" button. 

Power BI

Step 9

After publishing, copy the URL. Please refer the below screenshot.

Power BI

Step 10

Open your Office 365 account with valid username & password. 

Power BI

Step 11

Go to the Site where you want to use your Power BI Report. Click on "Add a page".

Power BI

Step 12

On this page, you will get a + icon. Click on that and choose Power BI (preview). The following screen will appear.

Power BI

Power BI

Step 13

Click on "Add Report" button & paste the copied URL as shown in the screenshot.

Power BI

Step 14

The report will appear on the screen. Now, click on "Publish". It will be showing on your SharePoint Online Page as shown in the below screenshot.

Power BI

So, this Power BI slicer can be used as a filter to filter your data for other Visuals.