Chart outcome as expected

[amalrio]

Hello experts, 

I have a chart rquirement that need to be achieve, below is the one I have currently, but I need it to be show like in image 2 whare you have two levels on x axis without drilling down, show year and related category (Primary, Ancillary) hope below images make sence, happy to provide more information on request.

Image 2 (desire chart outcome)

[v-eqin-msft · Accepted solution]

Hi @amalrio ,

Please sort the visualization by X-axis values, then disable the "Concatenate Labels" options like this:

Here is the pbi file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[amitchandak]

@amalrio , Not very clear.  Year on axis and category  on Legend of stacked.

[amalrio]

Hi @amitchandak , 

Thanks for the reply, 

what I want to see in my graph is each year for instence say 2017, two bars one for Primary , and One for Ancilary, both Primary and Ancliary totals are made of other categories too. total ancilary(CatA, CatB) total Primary(CatC,CatD,CatE).. that is why bars are stacked, hope this explains, if not please let me know.

[amitchandak]

@amalrio , Please check, if this can help

https://community.powerbi.com/t5/Desktop/Clustered-stacked-column-chart/td-p/75515

https://www.defteam.com/stacked-clustered-bar-chart/