1 of 1 people found this helpful
This is partly what I'm trying to do: https://public.tableau.com/views/ServiceChargesbar/Sheet2?:embed=y&:display_count=yes
However, it's sorting the data by category and I want to sort it by descending percentage portion.. which will jumble the coloured categories up but show the fields in order of size.
I just want to show how much each item represents as a portion of the total budget from most to least in a stacked bar, with each item in one of 5 colours showing which category it belongs to.
When the bands get very small, is there a way to stagger or explode the label marks, so they aren't hidden or layered over each other illegibly?
I hope this could help you, in Tableau we have a gerarchical order of disaggregation, when you put on the rows "Years" and at right of it "Month" is not the same thing of "Month" Years".
So even when you use the marks you have to respect an order of detail, the only thing that you should do is clear all sort and put charges first, after this you should click on the "Charges" Field to select it and again on the sort button, in this way you will sort the "Charges" field only.
For what concern the label the only thing that I do in this cases is to deselect the "Allow lable to overlap other marks" and I use a Crosstab to show the values if the user want to see it, in this case I use to do a tree map chart to could show a ranking and together all the values in the viz.
I did it an example here Tableau Public