Zebra BI for Power BI – January 2020 Update

The January 2020 Update of Zebra BI visuals for Power BI provides ultimate flexibility in designing table-based reports and offers complete governance of the design and behaviour of both Zebra BI visuals in Power BI reports and dashboards.

With major new features such as column subtotals and grand totals in Zebra BI tables that users can show or hide, rename and expand/collapse in one click, as well as with brand new governance options to control the design and behaviour of both visuals, Zebra BI is further empowering its users in their journey to Power BI reporting excellence.

Make sure you download the demo PBIX file, it contains all the latest features illustrated with many practical examples:

Video overview

Watch the video below for an overview of all major NEW features & updates in Zebra BI for Power BI January 2020 Update, illustrated with practical examples:

Interact with Zebra BI for Power BI, January 2020 Update

Browse our interactive example to get inspired and see all the latest features in action.

Make sure you put the interactive report in the full-screen mode (⤢) and check out all the pages by pressing the < and > navigation arrows:

What’s New?

Zebra BI Tables, January 2020 Update (version 4.0.2)

Zebra BI Tables, January Update (version 4.0.2) provides new features that further enhance the flexibility of table-based and matrix-based reporting.

This time the Zebra BI team has tackled the important challenge of column structures in tables by allowing users to easily manage:

  • Column grand totals
  • Column subtotals
  • Expand/collapse groups of columns
  • Renaming any column in a table (including subtotals and grand totals)
  • Sorting by any column or total in 1 click
  • Displaying any column (including the totals) as a table or a chart

Both the grand totals and the subtotals can be easily renamed, shown or hidden directly on the visual, which makes the user experience enjoyable and extremely fast.

In addition, the user can sort the tables by any column, subtotal or grand total in one click:

The new features work with all Zebra BI Tables layouts, charts, and settings. Here’s a real-life example where an additional measure for Previous year is added to the visual, thus creating a flexible variance table/matrix with automatically calculated variances and charts:

Zebra BI Charts, January 2020 Update (version 4.0.1)

Zebra BI Charts, January Update (version 4.0.1) now fully supports custom themes, provided in the extended JSON format. This allows users to set up their preferred theme/style or align their Power BI reports and dashboards with their company’s corporate design.

All colors and fonts, that were previously customizable on each instance of the Zebra BI visual or set centrally in the Zebra BI member portal (for Pro users), are now fully exposed and can be specified in an extended JSON format for Power BI themes.

Once you create a custom theme (JSON file) you can import it by using the standard Power BI Import theme command. The theme covers all design settings and options for all Zebra BI charts and tables in one place:

Even more importantly, a custom theme can now control any setting available in the Zebra BI Charts (as well as the Zebra BI Tables) visual. This provides extensive and detailed governance of all reporting aspects of Zebra BI for Power BI.

In the example below, a custom theme enforces grand totals in Zebra BI Charts by default, switches the data label format for negative numbers in both Zebra BI visuals to parenthesis instead of being presented with a leading minus (-) sign, and sets the policy of displaying axis labels to rotate instead of trim in cases where space is limited - all in one go:

Feeling inspired yet? Then try creating a custom theme that:

  • Inverts the meaning of variances in both Zebra BI visuals by default (e.g. in cost reporting, growing costs have a negative impact on company’s results so they should be displayed in red),
  • Choose whether the subtotals in Zebra BI Tables are displayed above or below child rows,
  • Enable or disable any of the interactive Zebra BI features for end-users in the view mode (e.g. changing the chart type, breaking the axis, changing the order of columns in a table and similar),
  • Etc.

Check out the documentation on custom themes for further details: http://zebrabi.com/power-bi-custom-visuals/customize-your-zebra-bi-visualizations-with-custom-themes/

Time to give it a spin!

If you're already using the AppSource version of Zebra BI (version 4.0.0 or higher), then your Zebra BI has already been updated via the Microsoft's AppSource marketplace automatically. You're good to go!

If you're using an older version of Zebra BI (e.g. 3.x.x or older), then this might be a perfect opportunity to update your Zebra BI! When ready, just shoot us an email at [email protected] and we'll help you migrate to the latest version.

Haven't tried Zebra BI before? Opt in for our 30-day free trial here: