Forum Discussion
Solved
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 ...
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 quick reply. I will try this out over the weekend and advise if it worked or not.