100% stacked bar chart - Y axis - max area width - can I fix the width

[Saniat]

Hi,

I am using a 100% Stacked bar chart, together with separate "total%" of it:

I have played around with the Y-axis: max area width, but as we can only play around with the MAX width, and cannot FIX it, I am facing problems when I am breaking down on different dimension, e.g.:

The detailed chart starts before the Total when Y axis label is shorter:

The detailed chart starts after the Total when Y axis label is longer:

This problem is based on the assumption of: We can only play around with the MAX width of Y-axis label, and cannot FIX it.

Is there any way to FIX this width - so I know exactly where the viz starts, and align the Total chart ?

Thanks.

[MFelix · Accepted solution]

Hi @Saniat 

Create a disconnected table with all the categories and a row with the total:

Then add the following metric:

Total values =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table (2)'[Cat] ) = "Total", SUM ( 'Table'[Value] ),
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[Cat] IN DISTINCT ( 'Table (2)'[Cat] ) )
    )
)

Now use this metric and the new table on the visual.

If you want you can add a sort id on the table so you have the values of the category in the correct order.