Split stacked bar chart by id displaying names

[fafernandez]

Hi,

I'm having trouble creating the right visualization for my bar chart.

I have a huge dataset that contains Name, ID and categoryID. The issue is that some data from the Name column have the same string, but different categoryID. When creating the bar chart I need to display the Name with he amount of activities (that comes from a different table which is linked by the ID) but split each one of them by categoryID. So that sometimes I could have 2 different fields from the Name column that are equally written but belong to different categoryID and therefore have different amounts of activities.

In summary i need to be able to differentiate each Name even if they are the same but still display them all 

[parry2k]

@fafernandez not sure what you mean. If you can provide some screenshots and the detail, it will be helpful to answer the question.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[fafernandez]

When adding a legend the bar colors change and i would need to change 1 by 1

[parry2k · Accepted solution]

@fafernandez you can use category column on the legend and that will show the same name twice.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[fafernandez]

Hi parry, 

It kind of worked, how ever my dataset is too large and now I would need to change each color manually right? Considering this is something that changes overtime its not the best solution. However it works to see the difference.