Need help with stacked bar chart visual

[abdulrafey]

I am new to power bi and facing difficulty in splitting the colors on the same bar in stacked bar chart. I have reached to this and cannot split colors on bar. Please help me with this.

 

[v-heq-msft · Accepted solution]

Hi @abdulrafey ,
Based on your description, you want to color split the bars by type. There are two prerequisites to accomplish this step, first for your sub-Category you need to have more than one under the same Category, as this is the category that is used as a measure of the length of the bar chart. Secondly you need to use stuck bar chart for this.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Final output

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[audreygerred]

When you say you are having difficulty splitting the color on the same bar - are you wanting the sub-categories to appear in the same bar, but different colors or are you wanting something else?

[Kiven03]

hi @abdulrafey ,

Instead of adding Sub-category in legend, add it in the Y-asix below Category and check.
I hope this is what you are looking for, please feel free to ask if you any further query.

Thank You
Vivek

[abdulrafey]

Sorry, it doesn't works. Please tell me the general way of doing it, do we have to write any query for data range. And what is DAX query and where it is written?

[Kiven03]

@abdulrafey 

No need of DAX its simple, with previous solution you need to click on drill down button, and then hold ctrl+ click on the specific bar.

You are not able to see the color splitting cause all the 6 cells of category and sub-category are different.

please check this video, to understand how to use bar chart. https://youtu.be/_LYN02Fi4Wo?si=A6QknXuY67k_FDNF

Thank you.