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

[gracylayla]

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.





Step 2

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





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.

Step 4

Select the required sheet and click "Load".

Step 5

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

Step 6

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

Step 7

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

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. 

Step 9

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

Step 10

Open your Office 365 account with valid username & password. 

Step 11

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

Step 12

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

Step 13

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

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. 



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

[v-yuezhe-msft]

@gracylayla,

Thanks for your sharing.

Regards,
Lydia