What do I need to do in Power BI to show this table as an area graph with an X axis of date and Y axis of value, with each of the categories stacked in value. I want to be able to show total and drill down into each category if necessary.
Darrin
Category | 01-Jan-22 | 01-Feb-22 | ######## | 01-Apr-22 | 01-May-22 | 01-Jun-22 | 01-Jul-22 | 01-Aug-22 | 01-Sep-22 | 01-Oct-22 | 01-Nov-22 | 01-Dec-22 | 01-Jan-23 | 01-Feb-23 | 01-Mar-23 | 01-Apr-23 | 01-May-23 |
Cat 1 | £500,000 | £569,722 | £81,776 | £113,583 | £115,506 | £153,297 | £153,297 | £170,743 | £242,794 | £230,740 | £198,933 | £198,933 | £181,487 | £111,765 | £111,765 | £111,765 | £1,923 |
Cat 2 | £0 | £0 | £0 | £381,738 | £524,656 | £224,656 | £224,656 | £189,151 | £189,151 | £81,738 | £81,738 | £81,738 | £0 | £0 | £0 | £0 | £0 |
Cat 3 | £0 | £0 | £0 | £0 | £0 | £103,691 | £103,691 | £103,691 | £103,691 | £103,691 | £103,691 | £103,691 | £103,691 | £0 | £0 | £0 | £0 |
Thats brilliant thanks!
Is it possible to manage more complex scenarios. For example if I had multiple projects in each category all with theire on row and calendarised costs):
Project 1, Cat 1....
Project 2 Cat 1...
Project 3 Cat 2...
Project 4 Cat 3...
Project 5 Cat 1...
....
....
And also is it possible to deal with the even more complex scenario of:
Project 1 Cat 1 High ....
Project 2 Cat 1 Low ...
Project 3 Cat 2 Current ...
etc?
Sorry for asking!!!
Darrin
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!