Featured in Microsoft's October 2018 Power BI desktop update, this Power BI custom visual is designed for easily comparing time series 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. Because this chart reports relative variance, we apply a lollipop design to show what you’re calculating variance against.
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
Note that the above design choices for this MS BI tool make it easy and intuitive to overlap different time periods.