cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gracylayla Regular Visitor
Regular Visitor

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.

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

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

@gracylayla,

Thanks for your sharing.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)