Return to site

Bar chart with relative variance

Power BI dashboard documentation and example report

· Power BI visuals,Power BI dashboard


Questions about this visual? Book an in-person call with our team now.

This Power BI custom visual is designed for easily comparing category data. It is built for reporting actual, forecast, planned, and previous year data and allows users to quickly identify when a series deviates from its baseline.

Influenced by IBCS, this Power BI dashboard applied information density principles including the sparing use of colors. Design semantics apply standardized conventions, with the following schema:

  • solid black for current year
  • grey for previous year
  • hollow for budget
  • shaded for forecast
Bar chart with relative variance, a Microsoft Power BI dashboard from 3AG Systems

Note that the above design choices make it easy and intuitive to overlap different time periods.

It is highly recommended to use these charts only for non-time series data. For time series reporting please consider using column charts, like Column Chart With Relative Variance.

Check out the how-to video below.

Full documentation is provided in the example report below. You can also download the Power BI desktop file here.

You can get the custom visual from Microsoft AppSource here.

All Posts

Almost done…

We just sent you an email. Please click the link in the email to confirm your subscription!

OKSubscriptions powered by Strikingly