Same values in multiple groups on one visualisation

[markeajones]

Hi all,

I'm trying to produce a visualisation that displays diversity amongst the various levels of our organisation. The way the business want it displayed means that an individual could be in more than 1 group. For example they might be in Grade 3+ and Grade 4+.

As the visual is about diversity the legend then shows the gender breakdown across each grouping, in something like a 100% stacked bar chart. 

I'm struggling to find a way to do this all in a single visual, and using multiple visuals is messy. The end user would like to see all of this on the screen at once so the comparison is easy between each grouping is easy to make, so using a slicer to move between the isn't particularly viable either.

[markeajones]

Hi all,

The solution I went with was to create additional reference tables, each with a different grouping attached to them. I then appended the tables together and was able to create the visual I needed so thanks for everyone's responses.

It's a little clunky and makes the dataset a lot larger which isn't ideal, but it does do what it needs to now.

[v-xulin-mstf]

Hi @markeajones,

Is your issue solved?

If the issue has been solved, please adopt the solution to help others

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf · Accepted solution]

Hi @markeajones

Is this what you want?

You need a table as:

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak]

@markeajones , this might require unpivoting and maybe sankey chart visual can do 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.