Forum Discussion
Recreate Stacked Chart from Excel
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 , 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
3 Replies
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
Thank you for the help; i restructured the data in my source Excel file and that sorted it out!
Thank you for the quick reply. I will try this out over the weekend and advise if it worked or not.
