Area graph -Power BI 101

[Darrin]

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

[lbendlin]

This is straightforward once you have brought your data into a usable format (by unpivoting the date columns)

see attached.

[Darrin]

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

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.