Recreate Stacked Chart from Excel

[csummers]

I have an Excel file that I have been working to recreate in PowerBI. One chart in particular is a stacked chart that was very simple to recreate but I have tried multiple things in PowerBI but keep ending up with a normal bar chart instead of a stacked chart. As you can see I just want to stack Employee and Contingent Headcount values, show a total, and a trendline on a monthly basis.

I suspect I am missing a measure or something but it is driving me crazy.... 😁 .

Thanks in advance for the help.

Excel Version

[csummers]

Thank you for the quick reply. I will try this out over the weekend and advise if it worked or not.

[amitchandak · Accepted solution]

@csummers , In power bi you need have data like

Date, user Type, Head count

a Measure = Sum(Table[Headcount])

You have used stacked visuals with the same measure for values and lines.

Axis as date. user type as legend - user Type

Unpivot the data, if needed, If the total is part of user type, create two-measure one only for total and one without total

https://radacad.com/pivot-and-unpivot-with-power-bi

[csummers]

Thank you for the help; i restructured the data in my source Excel file and that sorted it out!