IBCS® Certified
PBI Certified

Zebra BI for Power BI – 4.0.2 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.

Get the PBIX file

Download the demo PBIX file that contains all the latest features illustrated with many practical examples.
Download PBIX

Watch the Video

Watch the video below for a quick and practical overview of all major NEW features & updates:
(0:07) Intro to January update
(0:28) Expanding column subtotals
(1:03) Turning on/off subtotals and grand totals
(2:56) Custom themes
Share this

Interact with Zebra BI for Power BI, January 2020 Update 👇

Play with our interactive example to get inspired and see all the new features in action. 
Tip: Make sure you put the interactive report in the full-screen mode (⤢) and check out all the pages by pressing the navigation arrows.

So, what’s new? 🎉

Zebra BI Tables (Version 4.0.2)

Column structures

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 (Version 4.0.2)

Custom theme

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 this example, 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 

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 support@zebra.bi 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:

Start Your 30-Day Free Pro Trial