Stacked Column Chart Formatting

[0Experience]

Hi everyone,

I'm working with a stacked column chart in Power BI where:

• X-axis has a hierarchy: Year → Type
• Y-axis shows values from a measure
• Legend is based on Type

Currently, the chart displays Year and Type-1, Type-2, etc., on the X-axis, but I already have a legend at the top of the visual, so I’d prefer not to repeat those labels on the axis.

Here’s what I’m trying to achieve:

• Keep the stacked bar for Type-12, which includes Type-1 + Type-2
• Do not show separate values for Type-1 and Type-2 within Type-12. I want to display just the combined value (Type-1 + Type-2) as a single stacked bar

Expected something like below:

If anyone has suggestions on how to format or model this properly, I’d really appreciate your help!

You can access the Power BI file here

Thanks in advance!

[FBergamaschi]

Thank you for this clear post and for providing data

Done, here the result

my file is here 

https://drive.google.com/drive/folders/14HuWjOKld9A5x-oHacplyMRa6J5rNyjd?usp=sharing

What I did:

1 - created a column "Fake label" to have only empty spaces and so hide type 1 etc ut keep the different result and column for each

2 - created a DAX measure to avoid showing the value for type-12

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[0Experience]

I got the solution using total labels instead of data label.

Accepting your answer as got the idea from you for the fake label.

Thank you.

Update: The question has been reopened because the previous solution did not correctly address the data label issue.

[FBergamaschi]

More than welcome

[0Experience]

@FBergamaschi 

I think data label is not working properly.

If I use "Data label" with the measure you gave and turned off "Total labels" then I am not seeing the total of the type-12 (below screenshot)

If I turned on the "Total labels" then I am getting the below output

My expected output would be (I need one data label for every types).

Any idea how can I do this?

[0Experience]

@FBergamaschi Thanks so much for your time and help. Really appreciate it!

However, I was hoping to show a single value for type-12 (which is just the sum of type-1 and type-2), instead of leaving it blank like in the screenshot I attached with question.

I tried tweaking the 'level' measure you shared, but, I couldn’t get it to work. Not even sure if this is doable.

If you have any ideas or suggestions, please let me know!