STACKED BAR PLOT
The slope plot shows the value of the metrics available in the dataset in the t0 and t1 periods in absolute value or as % of the total.
The plot is run at the total plotted data level...
...and for each dimension. Categories are sorted by decreasing total amount value with "other rank > x" as last.
By clicking on a legend value you can highlight that value on the charts.
Labels and values are plotted in the chart, but are not shown for small, less relevant, items.
Longer labels that would not fit in the chart are automatically shortened.
SAVING THE PLOT
To save the plot as a PNG file, click on the small circle to the right of the legend, and select "save as PNG".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
If the dataset contains more than two periods, you can choose whether to plot all the periods or just the two periods of the variance analysis comparison.
If you choose to plot all the periods, (and the period aggregation is equal to year) you can choose whether to show the CAGR values or not.
If the widget is set to True, (non overlapping) CAGR values will be shown (light green "Pennsylvania" CAGR is not shown because it might not fit well).
By default all metrics present in the dataset are plotted. You can choose to plot only one metric, for instance "Amount".
Only the Amount plot will be plotted.
You can also change the order of the plot metrics. For instance instead of Units, then Amount, then Gross Margin you can choose a different order
The metrics will be plotted in the required order.
By default, the four top items in terms of total Amount of the two periods are plotted, while the other items are aggregated together.
You can change the number of top items, and you can choose not to plot the value of the other aggregated items.
NORMALIZED STACKED PLOT
Values can be plotted in absolute value, as a % of total dataset, as a % of total dataset after filters, or as a % of the result row. The last two options only make sense if you plot a result row.
Negative values - for instance negative margins - will be plotted, but without labels and with a vertical axis
In case of % stacked bar charts, if there are negative values, the chart will not be plotted and a warning message will be shown.
CHOICE OF COLOR PALETTE
This elegant palette is both beautiful and functional.
This bright palette contains clusters with distinct color separations.
This fresh palette contains modern tones and stunning highlight colors.
BLUE & GREEN PALETTE
This contiguous palette creates a bi-chromatic chart in cool subdued hues.
KHAKI & DENIM PALETTE
This subdued palette great for complex charts.
This subdued palette is good for charts requiring contrast between segments.
HEATING UP PALETTE
This bright palette is great for complex charts.
POWERBI DEFAULT PALETTE
A lively, colorful palette.
This functional palette minimizes the risk of confusion between colors .