Posted on

Exploring the Milestone Trend Analysis

Exploring the Milestone Trend Analysis

The Milestone Trend Analysis (MTA) is a simple method of early identifying deadline trends. It allows you to react in time with corrective actions. And it will raise the deadline awareness of all project participants and stakeholders.

Microsoft MVP Erik van Hurck reviews the Milestone Trend Analysis. Have a look at the video here

Try it yourself!

Do you want to try the Milestone Trend Analysis (MTA)? Download a trial from the Microsoft AppSource.

Posted on

Power BI Analytic lines

Constant line Strip Plot

Support for Power BI Analytics pane

We have added support for analytics features to some of our visuals. 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).

Use of Constant line, Min line, Max line, Average line, Median line and Percentile line is currently available on these visuals:

Dumbbell Bar Chart
Dumbbell Column Chart
Lipstick Bar Chart
Lipstick Column Chart
Lollipop Bar Chart
Lollipop Column Chart
Strip Plot

Using the Analytics pane

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

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

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.

Format your line by specifying the ColorTransparency percentage, Line width, style and position. For most lines you can specify the visual Measure to base your line upon, by selecting Primary or Secondary value from the drop-down menu.

If you want to have a data label, switch Data label On. You get additional formatting options for your data label, such as: Color, Text, Horizontal and Vertical position, Display units and Value decimal places.

For step-by-step instructions (with video’s and screenshots), visit our Knowledge Base and check the Tutorial: how to add Power BI Analytic lines available under each visual that supports Analytics lines. Or click the links below:

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, please contact us by email at Nova Silva Support or visit our Community forum.

Posted on

Reporting & Data Visualization Summit 2022

EnterpriseDNA Reporting & Data Visualization Summit 2022

Later this month Enterprise DNA organises the Reporting & Data Visualization Summit 2022. Over 5 days, 25+ training sessions for everyone working with Power BI. And in this case it is really for EVERYONE, because you can join this event for FREE.

Register HERE for FREE now!

We are honoured to sponsor this event and conduct one of the training sessions. Join us on Tuesday, May 24th for our session “9½ Tips for awesome visualizations in Power BI“.

Posted on

9½ Tips for awesome visualizations in Power BI

After two long years of attending all events virtually this month we finally could meet each other again. When we heard about the possibility to be part of the Dutch Power BI User Group event there was no doubt. We joined as a sponsor and enjoyed every minute of meeting all these Power BI users. Our colleague Michel had the honour to talk about his passion: effective data visualization in Power BI. Really excited to share his story with the audience, but also with anyone else who tries to get most out of their Power BI visualizations.

In case you could not join the event, here you can watch the video of our presentation. ½

Posted on

PowerGantt Chart for Power BI

The Gantt chart is an excellent tool to visualize your program and project schedules and task dependencies. The horizontal bars show for each task/activity the period between the start and end date (or time). Icons can be used to represent milestones: important moments within your project timeline.

The PowerGantt Chart allows you to review both tasks/activities and milestones right in your Power BI reports. The PowerGantt Chart supports unlimited number of task/activities, hierarchy levels and number of milestones.

Key features of the PowerGantt Chart are:

  • Insight into your program and project schedules: high level overview at first and dive into details using the collapse/expand buttons. Zoom into specific periods using the dynamic zoom slider
  • Highly customisable: Add or remove columns, change colors of bars based on your own criteria, and change the date granularity
  • No need to learn a new interface. Configuration is the same as a standard Power BI Bar Chart. And of course, theme colors and settings are supported

Don’t hesitate and try the PowerGannt Chart now on your own project/program data by downloading it from the AppSource.

Posted on

Strip Plot for Power BI

In the Microsoft Power BI Blog post of March 2022 we got the opportunity to share some exciting updates in our Strip for Power BI. Here you have our contribution to the Power BI Blog.

Most charts will force you to summarize or categorize data before it is displayed. This can hide important details and may be misleading. The Strip Plot shows all your data observations in one go without hiding important details. It shows each data point on a single continuous scale.

You gave us excellent feedback which allows us to further improve this visual. Based on your feedback we just released version 2 with several exciting enhancements.

You could already add numeric values, but now you can also use dates on the x-axis. The x-axis has also been enhanced with the optional Zoom-Slider.

Each visual in Power BI has three different panes: Fields, Format & Analytics. The Analytics pane allows you to add reference lines to your visual (like: fixed value, median, average, max, etc.) In version 2 you can use this functionality with the Strip Plot.

All functionality of the Strip Plot is available through the standard Power BI interface: NO need to learn any new interface.

Don’t hesitate and try the Strip Plot now on your own data by downloading it from the AppSource.

Posted on

Merged Bar Chart for Power BI

In the Microsoft Power BI Blog post of February 2022 we got the opportunity to share some exciting updates in our Merged Bar Chart for Power BI. Microsoft has included this visual in the exclusive Editors Pick list. Here you have our contribution to the Power BI Blog.

On the surface the Merged Bar Chart has a lot of similarities with small multiples. The key difference is the way these charts allow you to compare values. The Merged Bar Chart focusses on comparing multiple measures (like EBITDA & Marketcap in the example below) within one specific categorical variable (here Industries of S&P 500 stocks).

Based on your excellent feedback we have added several exciting features to this visual:

  • Conditional formatting: bars within a measure can change color (the example above shows the EBITDA/FTE in red when it concerns a negative revenue growth)
  • Data Labels: besides the bar you can show the data label. You can even change the location of the labels.
  • Partial highlighting: when your selection results in a partial match (in the example above this is the selection of Washington State) the partial highlight will display this with the highlighted color.

Do you want to compare multiple independent measures? Go Merged Bar Chart.

Try the Merged Bar Chart now by downloading it from the AppSource. All features are available for free to evaluate this visual within Power BI Desktop.

Posted on

Updated Shielded HTML Viewer

In the Microsoft Power BI Blog post of December 2021 we got the opportunity to share some exciting updates in our Shielded HTML Viewer. Here you have our contribution to the Power BI Blog.

All HTML rendered through the Shielded HTML Viewer is sanitised to keep your data safe. But sometimes our sanitation process is too strict. Based on valuable feedback from our users we concluded the use of images became a victim of this strict sanitation process. So, we added support for images to the Shielded HTML Viewer! But without the need for risky external links.

As of version 2.0 the Shielded HTML Viewer (in the image above used in the tooltip of a dumbbell chart) supports inline SVG and Data URL images. This way you can include any inline images in your Power BI reports and dashboards. Version 2.0 also includes support for the NAV-tag: now you can include HTML navigation menus to your reports. More information on the NAV-tag can be found here.

Furthermore, all functionality is available through the standard Power BI interface, so no need to learn a new interface.

Don’t hesitate and try the Shielded HTML Viewer now on your own data by downloading it from the AppSource. All features are available for free to evaluate the Shielded HTML Viewer within Power BI Desktop.

Posted on

Lollipop Bar Chart

Standard bar charts are ideal for showing a single measure per category. You can easily compare each of the categories with the rest. However, if you have larger number of categories (>10) in a bar chart it is possible the chart itself becomes “heavy”. The coloured bars will fill large part of the chart surface. To avoid this clutter one can use the Lollipop Bar Chart for Power BI as an alternative.

The Lollipop Bar Chart shows a marker (mostly a dot) per category. A subtle line connects the marker to the measure-axis origin. The marker combined with the line make it a Lollipop Bar Chart.

The Lollipop Bar Chart also contains an additional chart: the dot plot. Just hide the line connecting the marker to the axis.

The latest version of this chart contains several exciting enhancements:

  • Conditional Formatting (both the marker and the line)
  • Partial Highlighting
  • Data Labels
  • Marker shapes

Don’t hesitate and try the Lollipop Bar Chart now on your own data by downloading it from the AppSource. All features are available for free to evaluate this visual within Power BI Desktop.