Forum Discussion
Need help with stacked bar chart visual
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
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
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?
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.
