Help with Stacked chart - multiple values + detail

[jdusek92]

Hello,

I am recreating a Tableau Report into Power BI.

I have come across this visualization and data that I cannot mirror into Power BI:

Data is in this format - values are in Columns:

In Tableau it looks like this:

In Power BI I struggle to add the Gender detail just as it is in Tableau

Is it possible to recreate this visual in Power BI using the existing data structure?

I know I can have a duplicate table with unpivoted values, but that would create a mess in the data model. That is why I would like to find a solution with the data I have at the moment.

Warm regards,

Jakub

[mahoneypat · Accepted solution]

I agree you should unpivot your data.  You can add multiple columns (with auto aggregation of sum) to the values area of a bar chart but then you can't also add your gender column for the legend (as you've probably found out).  You might have to make this chart with the Charticulator visual.

(4) Season 1 - Charticulator - YouTube

Pat