The overlapping column chart(more advanced version in the below linked) is awesome, when comparing actual vs. forecast, plan prior year,etc.!
The standard clustered column chart in Power BI can be used to compare two measures, but when the value of the second measure is a component of the value of the first measure, an overlapping column chart can also be used to illustrate the comparison. Included here are two Deneb templates for creating such overlapping column charts.
Here is the base version of the visual:
A more advanced alternate version of the visual has also been developed that has…
Simple question (I hope) - how do you elminate the row and column axis titles? More complex question - how would you add a 3rd comparison, such as comparing actual vs. prior year and plan, probably by adding a line? Thank you for any asssistance.
To turn off axis titles, add an
axis-null key:value pair to the appropriate axis in the encoding block; here’s an example with the Y-axis turned off:
For additional comparisons, you can add other bar marks or tick marks as desired. Here’s a 4-bar/1-tick example of a bullet chart that may be of some interest.
The standard clustered bar chart in Power BI can be used to display a group of measure values for a set of categories, for example the channel sales for a country. An alternative could be a bullet chart with separate bars for the total and channel sales, and I enclose a Deneb/Vega-Lite template for a bullet chart displaying not only the total and channel sales, but a vertical bar at the 50% mark of total sales to add context.
This template illustrates a number of Deneb…
Hope it helps.
eDNA Forum - Deneb Overlapping Column V2.pbix (1.6 MB)