Forum Discussion
Recreate Stacked Chart from Excel
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
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!
