Tutorial: Purchasing, Assigning and Managing PER USER Licenses from Microsoft AppSource

Purchasing PER USER Licenses

To purchase a Nova Silva visual through the Microsoft AppSource, click Buy now and complete the Checkout path. See below

  1. Go to the Microsoft AppSource
  2. Click on the Nova Silva visual you want to purchase
  3. Optionally click the Plans + Pricing tab for an overview of the available plans and prices
  4. Click the Buy now button
  5. Checkout – Plan
    • Select a plan: Personal, Team, Departmental, Organisational or Corporate
    • Click Next button
  6. Checkout – Price + billing
    • Set Billing term to 1-month or 1-year subscription
    • Set Recurring billing: by default auto-renewal is On
    • Provide Number of users (both Creators and Viewers are considered Users)
    • Up next, choose your payment method: (You can pay with a credit card, prepaid cards are not supported)
    • Click Next button
  7. Checkout – Payment
    • Click Accept agreement and place order button

You can add a purchase number to the billing profile of your order. At the final stage of your checkout, select Add new under the billing profile and add the Purchase order number in field.

Billing and Global admins can also pay by invoice if that’s set up for your company. Read more about setting payment methods. Follow these steps to see your billing profile.

Assigning PER USER Licenses

After the purchase through Microsoft AppSource is complete and successful, the  buyer (owner) will need to assign the licenses to the users.

If the tenant admin owns the licenses (Org licenses), then any of the license admins (Global Admin, License Admin or User Admin) can manage the licenses.
However, if the subscription owner is non-admin, he will have access to the portal and only he can manage the subscription and licenses. The tenant admin can see all subscriptions purchased under the tenant account, including the subscriptions purchased by non-admins.

  1. Go to admin.microsoft.com and select the License link under the Billing node from the menu (a list of visuals appears)
  2. Click the Nova Visual Name you want to assign licenses for
  3. In the next page, click + Assign licenses
  4. Search by name or email address
  5. Select the user(s) you want to assign the licenses to
  6. Click Assign button

You can assign the license to the users directly by providing name or email, or through Microsoft Groups either Mail-enabled or Security Group.

If you were just assigned a license, refresh the report to activate it by doing one of the following:

  • If you’re using the licensed visual in the Power BI Service, refresh the report by hitting F5.
  • If you’re using the licensed visual in the Power BI Desktop, close and reopen it.

If, after you refresh, the license is still not available, wait a while and try again. It should be available within an hour.

Managing PER USER Licenses

Access the information about the licenses you purchased and manage it in Your Products under the Billing node in the Microsoft 365 admin center.

You can Buy licenses, Remove licenses, Edit recurring billing, View billing profile, Cancel subscription, View invoice, Turn on/ off recurring bill

For help managing licenses, contact support or click the Help & Support option on the bottom right section of your screen. If you raise a support ticket provide the Subscription ID.

Considerations and limitations

Currently, the following Power BI environments don’t support PER USER license management or license enforcement:
• Embedded – Publish To Web (public URL) , PaaS embed
• National clouds (Depends on general support for transactability in national clouds)
• RS Server (No planned support)
• Exporting (PDF\PPT) using REST API
For unsupported environments you need a PREMIUM license, this can be purchased from our webshop.

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

Here’s a short guide on how to add a license to our Power BI Premium visuals. The license can be set in two ways:

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

Adding a License Manually

To license the visual in the Power BI user interface, you need to apply the following steps:

  1. In Power BI (Desktop), add the visual to your Power BI Report
  2. Add data to the visual to activate the Format pane
  3. Open the Format visual pane
  4. Expand the License card and paste the license information into the License Name and License Key fields
  5. 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!

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 place your license information in a theme file it will apply the license to each visual.

How to update and import a theme file:

  • Create/ Update a JSON file with the visualStyles values (see examples below)
  • In Power BI (Desktop) go to View > Browse for themes
  • Select your Theme.json file and click Open button
  • 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 (if the License Name and Key field was empty, if not do a Reset to default)
  • 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”

Both the license name and license key are supplied to you specifically. 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

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

Hover over image or click to maximize

Adding Min, Max lines

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

Adding an Average line

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

Adding a Median line

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

Adding a Percentile line

  1. Add a Dumbbell Bar Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Percentile line
  4. Change Percentile line from Off to On and click to expand
  5. Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
  6. 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.

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.

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

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

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

Hover over image or click to maximize

Adding Min, Max lines

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

Adding an Average line

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

Adding a Median line

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

Adding a Percentile line

  1. Add a Lipstick Bar Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Percentile line
  4. Change Percentile line from Off to On and click to expand
  5. Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
  6. 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.

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.

Tutorial: how to add Power BI Analytic lines

Adding Analytic lines to a Dumbbell Column

The Dumbbell Column 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

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

Hover over image or click to maximize

Adding Min, Max lines

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

Adding an Average line

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

Adding a Median line

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

Adding a Percentile line

  1. Add a Dumbbell Column Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Percentile line
  4. Change Percentile line from Off to On and click to expand
  5. Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
  6. 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.

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.

Tutorial: how to add Power BI Analytic lines

Adding Analytic lines to a Lipstick Column

The Lipstick Column 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

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

Hover over image or click to maximize

Adding Min, Max lines

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

Adding an Average line

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

Adding a Median line

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

Adding a Percentile line

  1. Add a Lipstick Column Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Percentile line
  4. Change Percentile line from Off to On and click to expand
  5. Select Primary value or Secondary value from the Measure drop-down menu. By default the line is drawn on a Primary value
  6. 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.

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.

Tutorial: how to add Power BI Analytic lines

Adding Analytic lines to a Lollipop Column

The Lollipop Column 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

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

Hover over image or click to maximize

Adding Min, Max lines

  1. Add a Lollipop Column Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Min line and/ or Max line
  4. Change Min line and/ or Max line from Off to On and click to expand
  5. Optionally set properties as desired

Adding an Average line

  1. Add a Lollipop Column Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Average line
  4. Change Average line from Off to On and click to expand
  5. Optionally set properties as desired

Adding a Median line

  1. Add a Lollipop Column Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Median line
  4. Change Median line from Off to On and click to expand
  5. Optionally set properties as desired

Adding a Percentile line

  1. Add a Lollipop Column Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Percentile line
  4. Change Percentile line from Off to On and click to expand
  5. 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.

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

Tutorial: how to add Power BI Analytic lines

Adding Analytic lines to a Lollipop Bar

The Lollipop 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

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

Hover over image or click to maximize

Adding Min, Max lines

  1. Add a Lollipop Bar Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Min line and/ or Max line
  4. Change Min line and/ or Max line from Off to On and click to expand
  5. Optionally set properties as desired

Adding an Average line

  1. Add a Lollipop Bar Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Average line
  4. Change Average line from Off to On and click to expand
  5. Optionally set properties as desired

Adding a Median line

  1. Add a Lollipop Bar Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Median line
  4. Change Median line from Off to On and click to expand
  5. Optionally set properties as desired

Adding a Percentile line

  1. Add a Lollipop Bar Chart to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Percentile line
  4. Change Percentile line from Off to On and click to expand
  5. 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.

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

Tutorial: how to add Power BI Analytic lines

Adding Analytic lines to a Strip Plot

The Strip Plot 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

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

  1. Add a Strip Plot to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Constant line
  4. Change Constant line from Off to On and click to expand
  5. Enter a Value
  6. Optionally set properties as desired (for formatting options, see section How to: format analytic lines)

Hover over image or click to maximize

Adding Min, Max lines

  1. Add a Strip Plot to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Min line and/ or Max line
  4. Change Min line and/ or Max line from Off to On and click to expand
  5. Optionally set properties as desired

Adding an Average line

  1. Add a Strip Plot to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Average line
  4. Change Average line from Off to On and click to expand
  5. Optionally set properties as desired

Adding a Median line

  1. Add a Strip Plot to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Median line
  4. Change Median line from Off to On and click to expand
  5. Optionally set properties as desired

Adding a Percentile line

  1. Add a Strip Plot to your Power BI Report
  2. Select the visual
  3. Go to Visualizations > Analytics > Percentile line
  4. Change Percentile line from Off to On and click to expand
  5. 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.

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.
  • 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 our visuals, please contact us by email at Nova Silva Support.