Posted on

PowerGantt Chart for Power BI – Update

Earlier this year we introduced the PowerGantt Chart. We would like to thank you all for your excellent feedback and suggestions.

One suggestion we received from several users was to add a custom-date-scale to the PowerGantt Chart. This would significantly increase the number of possibilities, because there are unlimited number of custom date/time scales, like: fiscal years, special week numbers, AM/PM split of the day, etc.

Just after summer we released a new version of the PowerGantt containing this feature. You could already include unlimited number of tasks, hierarchy levels and milestones. Now every user of the PowerGantt can also define and include their own custom date scale.

Because the definition of a custom-date-scale requires the setup of a date table, we have created an instruction video where you’ll learn how to create your own custom date scale in a couple of easy steps. You can find this tutorial video HERE.

Don’t hesitate and try the PowerGantt Chart for FREE now on your own project/program data by downloading it from the 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

Shielded HTML Viewer for Power BI

All HTML rendered through the Shielded HTML Viewer is sanitized to keep your data safe.

The first HTML Viewer Certified by Microsoft now is part of the first Visuals you can buy and manage directly through Microsoft.

Microsoft announced this new functionality in July 2022. Currently in preview and requires Power BI Desktop July 2022 or later.

Obviously, this makes the purchase and management of licenses easier. Here are some of the main advantages:

  • Obtain fine grained control of the assignment of licenses.
  • (Re)assign each license to a user or group of users whenever you require.
  • Purchase a license for a single month or a whole year.
  • Make use of the optional auto-renewal feature.
  • No longer need to enter (or update) a license key. You manage your visual licenses like you manage any other Microsoft license.

Besides the Shielded HTML Viewer, all our visuals will support this new license option soon.

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

SMART KPI List for Power BI

Your incredible feedback allowed us to implement several exciting enhancements to the SMART KPI List.

Now you can extend the existing bar chart into a bullet graph by adding the qualitative ranges behind the bar.

Previously you had to choose between a bar chart and variance chart. Now you can show either or both at the same time.

You can also add additional columns to the visual to include more context. And all columns can be set to the exact right width by dragging the edges.

Don’t hesitate and try the SMART KPI List 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.

Posted on

Milestone Trend Analysis Chart for Power BI

Milestones in project management are points in time when important deliverables are due. Like begin/end dates of project phases, formal approvals, etc. Nothing new to most of us.

How can we use milestones to monitor the progress of our project(s)? The Milestone Trend Analysis Chart for Power BI.

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.

Key signals in the Milestone Trend Analysis Chart are:

  • Horizontal line: no change in the (expected) completion date
  • Increasing line: delay in the (expected) completion date
  • Decreasing line: (expected) completion date brought forward

All features of the Milestone Trend Analysis Chart are available in the familiar standard Power BI user interface. No need to learn a new interface. And of course, themes, interactive selection and tooltips are supported.

Don’t hesitate and try the Milestone Trend Analysis 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.

Posted on

Dumbbell Bar Chart for Power BI

Data visualisations play a fundamental role in answering an important data question:”How does result A compare to result B?”. Typical examples of these questions are:

  • How does the sales of this month compare to the sales of last month?
  • What is the difference between the number of documents processed this year compared to 2021?
  • How does the number of planned-visitors compare to the number of unplanned-visitors at our locations?

Key in answering these kind of questions is clearly visualising the difference between the two results. This is the strength of the Dumbbell Bar Chart: showing both values and the difference between them.

In the latest version you’ll find the features you asked for: data labels and conditional formatting. All available in the familiar standard Power BI interface. No need to learn any new interface to configure these features.

Don’t hesitate and try the Dumbbell 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.

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.