Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V

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

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.

1 ACCEPTED SOLUTION
Super User

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.

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

1 REPLY 1
Super User

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.

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors