Tutorial: Adding a PREMIUM License Manually or via a Theme file

This article provides a step-by-step guide for adding a license to our Power BI Premium visuals. You can license your visual in two ways:

Manually via de Power BI user interface or
Automatically via a Theme file.

Adding a License Manually

Follow these steps to license the visual in the Power BI user interface:

In Power BI (Desktop), add the visual to your Power BI Report
Click the Format your visual icon in the Visualizations pane or
Locate and open the existing report with the visual
Click the visual to activate the Format visual pane
Expand the License card and paste the license information (you received per e-mail) into the License Name and License Key fields
If the license information is entered correctly, you should see the expiry date of the license in the second field. Your visual is now successfully licensed!
Save your changes and Publish to the service.

Adding a License via a Theme file

You can also add the license to a Theme.json file to avoid having to add it to each visual individually.

Power BI Themes are defined in so called JSON files. If you add your license information in a theme file it will apply the license to each visual within that report.

How to create or update and import a theme file:

Create a new JSON file or edit an existing one
Add the visualStyles values (see example below)
Save the .json file
In Power BI (Desktop), create a new report and add the visual or
Locate and open the existing report with the visual
Go to the View tab and click on the drop-down arrow
Choose Browse for themes
Locate and select your Theme.json file
Click the Open button to import it
A File successfully added dialog will show up
Click the Got it button
Your report book and all the pages will get the refreshed License
Save and Publish to the service.

If you already have a corporate Theme file, add the “visualStyles” properties and paste it to your Theme file.

License properties

Name on user interface

License Name

License Key

Name in Theme file

“licenseName”

“licenseKey”

The License Name and License Key are supplied to you specifically via e-mail. Add the following example to your Theme file and replace the text between quotes with your own license information.

"visualStyles": {
       "*": {
          "*": {
             "license": [{
                 "licenseName": "YOUR LICENSE NAME",
                 "licenseKey": "YOUR LICENSE KEY"
            }]
        }
    } 
}

Tutorial: how to add Power BI Analytic lines

Adding Analytic lines to a Dumbbell Bar

The Dumbbell Bar Chart supports Analytics features, you can now add dynamic reference lines to mark important trends or insights. The analytic lines are under the Analytics pane in the Visualizations area of Power BI Desktop or service (Edit mode).

The Analytics pane only appears when you select the visual on the Power BI canvas

How to: use Analytics

Each visual in Power BI has three different panes: Fields, Format and Analytics. The Analytics pane allows you to add reference lines to your visual (like: fixed value, median, average, max, etc.)

You can highlight interesting trends and insights by creating dynamic reference lines with the Analytics pane. To add further analyses to your visual, select the visual and click the Analytics icon (magnifying glass), turn On the line(s) and click to expand and format your line.

Available Analytic lines:

Constant line: displays the value specified, helps to track metrics and desired goals.
Min line: displays the lowest value points on the axis.
Max line: displays the highest value points on the axis.
Average line: displays the data average.
Median line: displays the middle value.
Percentile line: displays the value (or score) below which x% of the observations may be found.

Adding a Constant line

Add a Dumbbell Bar Chart to your Power BI Report
Select the visual
Go to Visualizations > Analytics > Constant line
Change Constant line from Off to On and click to expand
Enter a Value
Optionally set properties as desired (for formatting options, see section How to: format analytic lines)

Example – The Constant line is drawn across the entire visual.
Analytic lines are drawn only in the primary chart

Hover over image or click to maximize

Adding Min, Max lines

Add a Dumbbell Bar Chart to your Power BI Report
Select the visual
Go to Visualizations > Analytics > Min line and/ or Max line
Change Min line and/ or Max line from Off to On and click to expand
Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
Optionally set properties as desired

Example – The Min/ Max lines drawn at the lowest & highest value points on the Primary value

Example – The Min/ Max lines drawn at the lowest & highest value points on the Secondary value

Adding an Average line

Add a Dumbbell Bar Chart to your Power BI Report
Select the visual
Go to Visualizations > Analytics > Average line
Change Average line from Off to On and click to expand
Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
Optionally set properties as desired

Example – The Average line displays the data average based on the Primary value

Example – The Average line displays the data average based on the Secondary value

Adding a Median line

Add a Dumbbell Bar Chart to your Power BI Report
Select the visual
Go to Visualizations > Analytics > Median line
Change Median line from Off to On and click to expand
Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
Optionally set properties as desired

Example – The Median is the 50th percentile or middle value on the Primary value

Example – The Median is the 50th percentile or middle value on the Secondary value

Adding a Percentile line

Add a Dumbbell Bar Chart to your Power BI Report
Select the visual
Go to Visualizations > Analytics > Percentile line
Change Percentile line from Off to On and click to expand
Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
Optionally set properties as desired

By default percentile is set to 90%, you can increase/ decrease the percentage value with the toggle bar or up/ down arrows.

Example Primary value – 90% of observations in the data are below that resulting value and the other 10% are above

Example Secondary value – 90% of observations in the data are below that resulting value and the other 10% are above

Percentile Formula

We use the same formula as the PERCENTILE() function in Power BI
P = K * (n – 1) + 1
Where:
n = number of values in the data set
K = given percentile
Or
Percentile = Given percentile * (total number of values – 1) + 1
The percentile is defined as this: if K is the percentile, then K% of the values should be below it. For example, the 90th percentile is a value where 90 percent of the observations in the data set or group are below. This means the percentile is based on a data point.

How to: format analytic lines

Formatting options for analytic lines are in line with the options you are familiar with from Power BI. Theme colors and settings are also supported.

Once you add a line or multiple lines, you can change the color, transparency, width, style and position of each line. Enable the Data label to add a label next to the line and get additional options for your data label. You can edit the color, text, position and set the display units and decimal places.

Available formatting options:

Value* – This property is only available in a Constant line, here you can provide the value on the axis where the line will be rendered.
Percentile*- This property is only available in a Percentile line. By default 90%, you can increase/ decrease the value.
Measure* – This property is available in visuals that support multiple measures such as the Lipstick and Dumbbell charts. Here you can add an analytic line to the Primary value or Secondary value. By default a line is set on a Primary value, click on the Measure drop-down menu to select the Secondary value.
Color – This property allows you to select a color for the line.
Transparency – This property determines how bright the line will appear on the visual. By decreasing transparency to zero, the line is a pure solid color line, increasing transparency to 100% will make the line invisible on the visual. By default transparency is set to 50%, so the line blends partially into the visual.
Line width – This property determines how thick the line will appear on the visual. By default is set to 3.
Line style – This property determines the style of the line as a continuous line ‘solid’, made up of dots ‘dotted’ or short strokes ‘dashed’. By default is dashed.
Position – This property allows you to set the position of the line: ‘In front’ or ‘Behind’ the bars. By default is In front.
Data Label Off – This property allows you to display text in the form of a data label for the line. By default, this property is set to ‘Off’.

Data label On – Change to ‘On’ to get options to format the data label.

Color – This property allows you to select a color for the data label.
Text – This property sets the value, name or both: ‘Data value’, ‘Name’, ‘Both’.
Horizontal position – This property sets the position of the data label: ‘Left’ or ‘Right’.
Vertical position – This property sets the position of the data label: ‘Above’ or ‘Under’.
Display units – This property determines the units: ‘Auto’, ‘None’, ‘Thousands’, ‘Millions’, ‘Billions’, ‘Trillions’. By default is Auto.
Value decimal places – This property allows you to set the number of decimals for the value. By default is Auto.

‘Reset to default’ or switch ‘Off’ to remove line and formatting options.

Try it yourself!

Do you want to try the Analytic lines in our visuals? Download any of the visuals available that support Analytics features from the Microsoft AppSource.

For any questions or remarks about this visual, please contact us by email at Nova Silva Support or visit our Community forum.

Video Tutorial: how to add a custom date scale

In this video you’ll learn how you can add a custom date scale to your Power Gantt Chart.

Tutorial: how to add Power BI Analytic lines

Adding Analytic lines to a Lipstick Bar

The Lipstick Bar Chart supports Analytics features, you can now add dynamic reference lines to mark important trends or insights. The analytic lines are under the Analytics pane in the Visualizations area of Power BI Desktop or service (Edit mode).

The Analytics pane only appears when you select the visual on the Power BI canvas