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. ...

Create Event Calendar In Power BI

Overview In this article, we will learn how we can create Event Calendar within Power BI. We have a requirement from many of my clients to show Events within the Calendar by Category Colors. In order to achieve that requirement, we can use the custom visual from the marketplace which is “ Calendar by MAQ Software ”. You can directly download it using   URL . At the end of the article, you are able to create Event Calendar as shown in the following screenshot. We have the following data to be shown in the event Calendar. Event Start Date Event End Date Description Category   For your practice, you can download sample data source file and Power BI file using   GitHub . Let’s get started! Step 1 Import “ Calendar by MAQ Software ” from Marketplace or download using the   URL . Once it is imported we can see the visual in visualization pane. Step 2 Drag the “ Calendar by MAQ Software ” visual and set the following property. ...