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.

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.  

Grouping
Click, drag and drop any header along the columns to change the order.
Column order
Click, drag and drop any column header outside the container to remove that column from the view. The column can be made visible again via the columns option in the sidebar of SuperTables. SuperTables - how to hide a column in your SuperTables view
Click on a header to sort the rows in an ascending order. Click again for a descending order, a further click will bring you back to the original sorting order. You can also select a secondary sorting column, just hold the Shift key while clicking the second column header. For example, your first sorting is on “Product Category” and the second sorting is on “Customer Segment”. When using multiple columns for sorting, you will see a small integer appear in the column header to indicate the first, second, third etc. columns you sorted the data on. Sorting columns in SuperTables. Use one column to sort or multiple columns to sort on.

SuperTables Features

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. 

Sidebar Column Pane in SuperTables
In the Sidebar on the right side of your SuperTable you also see a “Filters” tab. When you open this tab, you can click on any column header and filter though the filter pane.  Use the dropdown to choose which filter you wish to use and use the text box that will show up to dynamically filter your chosen column. You are able to do multiple filters at once.
Sidebar Filter pane in SuperTables

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.

Row groups in SuperTables
Just like in Excel, you can double click on the separator between column headers. This will automatically auto size the width of the column. You can also click on the hamburger menu alongside the column header, where you can auto size the selected column or all auto size all columns, just with one click!
Autosize in SuperTables

With the context menu of SuperTable you can quickly select some basic functions. Just right click on your SuperTable!

Right clicking on a cell and choosing  ‘Keep Only’ will filter and inline the column with just the chosen cell content. This can only be done on one value per column.
Keep only
Right clicking on a cell and choosing  ‘Exclude’ will exclude that and all others within your column with the same content. This can only be done on one value per column.  
Exclude in SuperTables
When sharing data, you may wish to hide certain information. This can be done by right clicking on any cell (or range of cells) and click on ‘Anonymize’. This will show ‘NN’ instead of its data. Reload the extension to clear the anonymization. 
Anonymise in SuperTables

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.

Clear all active filters in one foul swoop by right clicking anywhere on your SuperTables and then going to ‘Clear all filter(s). See it below in action.

SuperTables - clear all filters

Format pane

This section describes the configuration of your SuperTable. In the Format pane you can change a lot of settings.

Layout options

Multiple Row Selection

When using devices where Ctrl and Shift is not an option, turn on this feature where each click of a row will keep all rows selected. Clicking on a selected cell will deselect the row.

Enable/disable status bar

This option lets you toggle the visibility of the status bar in your SuperTable. The status bar is shown in SuperTables at the bottom and holds information on the total number of rows and filtered rows..

Grouping options

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 group totals within each group level

Each level will show a total of the group. Below, an example of the group total for “Office Supplies”:

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.

Pivot options 

Enable Pivot Header

Show or hide column headers when in Pivot mode.

Enable row total columns for each value at end of pivot table

Enable or disable row total columns for each value at the end of the pivot table.

Charting 

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.

Interactivity

Do you want to have a interactivity with an other visual? Turn this function on!

Sidebar

Enable/disable sidebar

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

Filter

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

Column Type

Text

Default columns are set to image, they will get the type out of Power BI.

Image

Does your dataset has an image? Select this option and you can see your image in SuperTables!

HTML

If you’re dataset has an html inside it, show it like this with the column type HTML

Markdown

If you’re dataset has a markdown inside it, show it like this with the column type HTML

Emoji

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. 

Column alignment

Choose the alignment of the text within your SuperTables view.

URL action

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  

Restrictions

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.

Theme

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!

Licensing

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.

About

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.