SuperTables Product Guide
The main use case for SuperTables is to offer more flexibility to your viewers in handling tables in Power BI. Using a table in your reports comes in handy if you want to provide your viewers with extra context on their visualization or let them make their own groupings, filtering and cross sections. SuperTables provides your viewers with a table that supports inline filtering, pivoting, grouping and many more features of which they can create their own personalized views. Drag the visual to the page, select the fields that you need to feed the table and you’re ready to offer your viewers Excel like functions without leaving Power BI! You’ve never seen a more powerful table!
We recommend to use a maximum of 30k rows for optimal performance. Anything above 30k rows makes the visual slower due to limitations from the Microsoft API.
Enter text into the search box underneath the column header you wish to filter. This will instantly filter inline and can be done on multiple columns simultaneously and offer your viewers the most flexible way of filtering their rows based on column values. To enable Inline Filtering, open the format pane within the visual. Set the Filter to “On” if you wish to have an inline filter.
Dragging and dropping headers into the grouping bar will allow the users to drill down on their data. To enable this feature, go to the Format pane under the Grouping options tab, you can tick the ‘Enable group bar’. Also, within the Grouping options tab, you will see ‘Use multiple columns for grouping’ this will group all the columns you wish to drill down in a group within the view.
This section describes the flexible ‘Excel like’ features SuperTables has to offer for your viewers.
On the right of the table (or left if you enabled Right to left in layout options) you see a side pane we call the Sidebar. By default you will see a “Column” tab as well as a “Filter” tab. In the column tab you can check and uncheck tick boxes to show/hide columns you would like to see in your SuperTable.
An amazing feature of SuperTables is that it allows your viewers to create their own grouping hierarchy. This can be done without the need of a Power BI fixed Hiearchy and in any order your viewers would like. To use this feature just drag a column to the grouping bar and drop it in the grouping bar. The rows will now be aggregated based on the grouping which you can select yourself. You can use multiple levels of grouping to create your own hierarchies just by adding columns to the grouping bar.
With the context menu of SuperTable you can quickly select some basic functions. Just right click on your SuperTable!
If you wish to export some, but not all rows or cells of your data, you can copy them from your SuperTable into your clipboard for later use in a report or excel environment. Highlight or select the rows or cells which you wish to copy by ticking the checkbox on the far left of your Supertable. Then, right click anywhere (in your selection) and click ‘Copy with headers’. This will save the information to your clipboard for you to paste outside of PowerBI in for example your email, a Word report or Excel workbook.
Empower your advanced dashboard users! Let them make columns out of values by pivoting on the data right in your table, similar to Pivot Tables in Excel. Open the Sidebar of your SuperTables and enable “Pivot mode” in the “Columns” tab. You can now configure row headers and columns based on groups or dimension values you like. You can, for example, replace the the column header “Category” with its values (for example “Office Supplies, Furniture and Technology” and have the rows show the “Regions” and “Ship Mode” like the example below.
This section describes the configuration of your SuperTable. In the Format pane you can change a lot of settings.
Enable Group bar
Show or hide the grouping bar in SuperTables. This enables or disables your dashboard users to do custom groupings on the dataset you offer in your SuperTable instance.
Enable a ‘grand’ total across all groups
Show a grand total of all groups in your SuperTable view.
When Group is expanded, hide the parent row
SuperTables allows you to hide the parent row while drilling down in your table. Below, an example with the parent row enabled:
Also an example with this option set to hide the parent row:
Hide the number of rows counter behind a group row
Normally, SuperTables shows the number of rows contained in a group or aggregation. With this switch you can turn off this row counter. By default, SuperTables shows a row counter when grouping:
You can switch this off and then the SuperTable groupings look like this:
Use multiple columns for grouping
When you use the grouping bar, SuperTables uses one column for the group by default. With this option, you can force SuperTables to use a dedicated column for each member of the grouping hierarchy. Example: Below you see a custom group of “Category” and “Sub category” where there is also a separate column for “Sub category”:
Default SuperTables combines the grouped dimensions into one column called “Group”:
Show aggregation function in header
When using Measures in your SuperTable, the aggregation of the column can be shown in the SuperTable column header using this switch:
Automatically expand grouped rows
If your SuperTables has multiple groups, you can set it to open on a specified level by default. If you have, for instance, 3 group levels, you can choose to expand it by default on the first level by setting this value to 2.
Create a pop-up chart of your selection. Within your SuperTable, select some dimensions and measures, right-click and choose ‘Chart Range’. Here, you will be presented with a selection of charts. Click on your desired choice and you will be presented with a pop-up chart within your dashboard. This is read-only and will not be stored in your SuperTables configuration and settings. It is designed to help your viewers with some extra self-service analytics on the SuperTables data.
Enable the option to show or hide the sidebar in the SuperTables visual for Dashboard users. You can also individually set this option for only the
- Columns panel
- Filter panel
- Formulas panel
Do you want to have a filter field for each column? You can set the field type in this section to filter text, numbers and dates
Default columns are set to image, they will get the type out of Power BI.
Does your dataset has an image? Select this option and you can see your image in SuperTables!
If you’re dataset has an html inside it, show it like this with the column type HTML
If you’re dataset has a markdown inside it, show it like this with the column type HTML
Why not use some emoji in your table? Use Unicode to set some emoji in SuperTables
Column image settings
Add the width and height in px in to the text boxes.
Enable ‘auto row height based on cell content’ under the Appearance tab to enable larger images in the grid. We suggest using square images for better layout control. Leave width and/or height empty for auto detection.
Choose the alignment of the text within your SuperTables view.
Entering a URL will allow users to click any cell in this column to open a new tab in their web browser. You refer to any other value from the same row of data by wrapping the field name with angle brackets. For example
Use the this tab to decide what the users will be able to do once you publish your report. By default, there are no restrictions set in SuperTables. If you decide it is better for your use case to restrict people from some of the SuperTables functions, you can set it up in this configuration. screen. User can adjust column width When creating a pixel perfect dashboard, you might want to fix the column widths in your SuperTable. This option prevents your viewers from changing the column width. User can sort columns Some use cases require a strict sorting of the columns in your SuperTable. This option helps you maintain that sorting by preventing the viewers to change the column sorting in your SuperTable. User can order columns Some use cases require a strict order of the columns in your SuperTable. This option helps you maintain that order by preventing the viewers to change the column order in your SuperTable. User can anonymize data You can either allow or deny your viewers to use the Anonymize function of SuperTables. User can Copy data The great thing of SuperTables is that you dimmish the demand for working with Exce However, SuperTables allows users to copy selections of rows/cells to the clipboard by default. This option can prevent your users to copy the data of SuperTables to the clipboard. If the editor wants to see what a viewer will see just use the Show user view, now you can edit everything wat a viewer will see.
Your reports are about to look even better! Our most recent upgrade of SuperTables allows creators to match their SuperTables extension to their report branding. Color your headers, text, borders and background to the theme you and your users recognize!
Use this tab when you recived a license key from AppsForPowerBi. Copy and paste the license key and click on enter.
When you have a valide license you will see your company name and email, amount of users en expire date.
Here, you will find which version of SuperTables you are using and the Infotopics | Apps for Power BI website link.
We love to make solutions and help Power BI users to do things more efficiently. If you have feedback, ideas, questions or need support, please share them with us! Also, don’t forget to follow us on social media for our latest news and updates.