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:
- hiding legend
- hiding Y axis
- 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),'%)')