Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |