This section describes the configuration of your SuperTable. In the Format pane you can change a lot of settings.
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..
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.
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.
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.
Do you want to have a interactivity with an other visual? Turn this function on!
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.