Forum Discussion
Advocate IIIHelp with Stacked chart - multiple values + detail
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
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
1 Reply
- mahoneypat
Microsoft Employee
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