Skip to main content

New Power BI Feature - Selection Pane In Power BI (Preview Feature)

Overview
Microsoft recently added one interesting feature in Power BI, i.e., Selection Pane. This is an amazing preview feature rolled out by the company during the October update. Before we start, we may have a question in our mind how this feature will be helpful to us.
Suppose, I have added 10 visuals in my single page of the report and while publishing this report, I only want to show 8 visuals. I want to hide other two visuals. This is where the selection pane feature comes handy.
Secondly, we can combine this feature with Bookmark Pane feature. For every bookmark in a bookmark pane, Power BI provides one selection pane. Sometimes, when we perform slideshow to the client with Power BI Desktop, we can hide unnecessary visuals within a click to focus a specific visual.
Now, let us check its amazing functionality!
In this article, steps 1 to 5 focus on the Selection Pane only.
Then, from Step 6 onward, we combine this Selection Pane feature with Bookmark Pane for better understanding. I prefer you to go through my previous article - Power BI New Feature: Bookmark Pane in Power BI (Preview Feature).
Prerequisites to enable this feature
  • Latest version of Power BI Desktop
  • Enable Preview Feature for bookmark ( To know how to enable preview feature in Power BI Desktop, visit my blog)

Step 1
Make sure the Bookmark Preview feature is enabled. To check, go to File > Options and Setting > Option > Preview Feature > Bookmark.
Make sure that the "Bookmarks" option is checked.

 
Step 2
If we have enabled this option, it provides us two panes under View option.
  1. Bookmark Pane
  2. Selection Pane

 
Step 3
Go to View > Check "Selection Pane".

 
It will add the Selection pane just after the Visualizations tab.

Step 4
If we observe, the selection pane has two options.
  • Show All – Used to show all visuals
  • Hide All – Used to hide all visuals
  • Along with this, it is showing all available visuals with visibility (glass icon right side) – We can hide specific visuals using this glass icon.


 
Step 5
Now, I want to hide the able visual.
So, I will close visibility icon of “September Tweet Records”. So, my table visual is now in hidden mode and my glass icon is converted into minus (-) icon.

 
If we want to show it again, click on (-) icon. The visual will appear.

 
Step 6
For better understanding and use of this Selection pane feature, let’s combine this feature with Bookmarks pane. In my previous article, we have created Bookmarks pane with 5 bookmarks added. Power BI shows Selection pane with all available visuals for each bookmark.
For every bookmark, we can hide and show visuals.

 
Step 7
Now, for the first bookmark, let’s hide the table visual.

 
For the second bookmark, let’s hide pie chart.

 
Remember: For each bookmark, it will not remember its previous state which means if we move to the next slide, the previous slide’s visuals are automatically shown.
Step 8
Selection Pane remembers its state at page level.
Bookmark pane remembers its state at page level as well as at the report level.
Step 9
Let’s publish a report. Now, let’s enable bookmark pane in Power BI published report.
Click View > Enable Selection Pane.

 
It will add a Selection pane. But here comes one limitation that I face, i.e., it will not provide the feature of show or hide visuals after publishing a report.

 
Conclusion
This is how this new preview feature, Selection Pane, works!

Comments

Popular posts from this blog

How to partition or split DataTable in C#?

Today we will discuss how we can divide or split a very large data table into fixed size of chunks? Scenario: Suppose there is a data table which has 1000 Rows. When you perform for each loop on data table and read each row at that time it will take too much time. If we devide 1000 Rows datatable into 10 fixed sizes (e.g. 100 Rows) datatable, It will take less time. Let's check how to achieve it. Here is a code. private static List<DataTable> SplitTable(DataTable originalTable, int batchSize) { List<DataTable> tables = new List<DataTable>(); int i = 0; int j = 1; DataTable newDt = originalTable.Clone(); newDt.TableName = "Table_" + j; newDt.Clear(); foreach (DataRow row in originalTable.Rows) { DataRow newRow = newDt.NewRow(); newRow.ItemArray = row.ItemArray; newDt.Rows.Add(newRow); i++; if (i == batchSize) ...

How To Lock Objects In Power BI

Overview Sometimes, there is a situation where when we open a report and click on any visual it accidentally nudges a chart a little bit to the right or left. Sometimes, by mistake when viewing a report, the arrangement of visuals scatters a little bit. Microsoft rolls out one new amazing feature to resolve this issue, that is, Lock Objects in Power BI. Advantages of using this feature When our purpose is to only view a report, this feature is a boon for us. Visualization’s position is not changed. Saves a lot of the developer's time to resolve the position related issues. Note   -  This feature is not saved with the report. So, every time you open a report, you need to enable this feature. Now, let’s understand this feature in a brief manner. To understand this, I will first show you one report in which I have not enabled “Lock Objects” feature. Step 1 The below screenshot shows my report which doesn’t have the enabled Lock Objects feature. ...

Use SharePoint Online List As A Data Source In Power BI

Introduction In this article, we will check how we can use SharePoint List as a data source in Microsoft Power BI. Please follow the below steps to establish the connection of SharePoint Online list with Power BI.  Step 1 Open Power BI Desktop > Get Data > Click More.   Step 2 Search for SharePoint > SharePoint Online List.   Step 3 Enter the URL of your SharePoint site.   Step 4 Click on Organizational account > Sign In.   Step 5 It will open the screen of Office 365 Login > Enter Credentials.   Step 6 Click on Connect.   Step 7 It will show all the lists available in the SharePoint - lists are on the left corner and their preview is on the right. Select all the lists which you want to use directly in the Power BI. Click on Load.   Step 8 It will load all the lists. Expand "Fields" column to view all the fields shown in the SharePoint List.   We can also view all the...