Single bar with stacked dimension break out

A pie chart requires one dimension and one measure. While stacked bar charts require two dimension and one measure.

This makes it hard to take a pie chart and easily convert to stacked bar. Since you need another dimension field.

One way to overcome this is by putting a static value / string as the X or Y axis. Here we have used “blank” in place of the Y-axis shelf.

With some more setting tweaks:

  1. hiding legend
  2. hiding Y axis
  3. adding label field - an expression that combines dimension value with percentage calculation using window function as follows:
    concat_ws('',max([Order Priority]),'(', cast(round(100*sum([Sales])/sum(sum([Sales])) over(),0) as STRING),'%)')

1 Like