https://store-images.s-microsoft.com/image/apps.9756.326506d0-6fc1-437f-aeb2-ae1d78b292db.609a835a-96a3-4916-b28e-f35cf5863d9e.91f5e991-9250-40b4-9916-f7b1c1d83fcf

3AG Systems - Bar Chart With Relative Variance

by 3AG Systems

Microsoft PBI Certified
(4 ratings)
Download SampleInstructions

Calculates percentage change and displays an overlapped bar chart with lollipop variance

Bar Chart with Relative (%) Variance automatically calculates relative or percentage variance between two scenarios and generates an overlapping bar chart that displays the relative variance with a lollipop chart situated parallel to the chart. The visualization is meant for comparing Actual, Forecast, Planned, and Previous Year data. Formatting for the charts is influenced by the International Business Communication Standards (IBCS). Customization available includes inverting the colors for red and green, resizing the data label font sizes, highlighting data labels, hiding data labels, drill down by category, adjusting units(to thousands-K, Millions-M, Billions-B) and more. This visualization is ideal for comparing “Actual vs. Planned”, “Actual vs. Previous Year”, “Forecast vs. Planned”, and “Forecast vs. Previous Year”.

Visual capabilities

This visual is certified by Power BI

At a glance

https://store-images.s-microsoft.com/image/apps.63591.326506d0-6fc1-437f-aeb2-ae1d78b292db.609a835a-96a3-4916-b28e-f35cf5863d9e.fcf6406f-a594-4b9e-a875-1b0c93aae5f4
https://store-images.s-microsoft.com/image/apps.49281.326506d0-6fc1-437f-aeb2-ae1d78b292db.609a835a-96a3-4916-b28e-f35cf5863d9e.7c3706c1-c9a4-4c0c-a038-bdcbac84786b
https://store-images.s-microsoft.com/image/apps.4864.326506d0-6fc1-437f-aeb2-ae1d78b292db.609a835a-96a3-4916-b28e-f35cf5863d9e.ff1403c1-c8b4-48f6-a3fd-1bafd017a28c
https://store-images.s-microsoft.com/image/apps.40580.326506d0-6fc1-437f-aeb2-ae1d78b292db.609a835a-96a3-4916-b28e-f35cf5863d9e.2d6faa90-0fdb-4776-bea5-87862fb00c0a