Forum Discussion
Area graph -Power BI 101
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 |
3 Replies
This is straightforward once you have brought your data into a usable format (by unpivoting the date columns)
see attached.
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.
