topic Area graph -Power BI 101 in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2927319#M6271 <P>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.&nbsp; I want to be able to show total and drill down into each category if necessary.</P><P>&nbsp;</P><P>Darrin</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Category</TD><TD>01-Jan-22</TD><TD>01-Feb-22</TD><TD>########</TD><TD>01-Apr-22</TD><TD>01-May-22</TD><TD>01-Jun-22</TD><TD>01-Jul-22</TD><TD>01-Aug-22</TD><TD>01-Sep-22</TD><TD>01-Oct-22</TD><TD>01-Nov-22</TD><TD>01-Dec-22</TD><TD>01-Jan-23</TD><TD>01-Feb-23</TD><TD>01-Mar-23</TD><TD>01-Apr-23</TD><TD>01-May-23</TD></TR><TR><TD>Cat 1</TD><TD>£500,000</TD><TD>£569,722</TD><TD>£81,776</TD><TD>£113,583</TD><TD>£115,506</TD><TD>£153,297</TD><TD>£153,297</TD><TD>£170,743</TD><TD>£242,794</TD><TD>£230,740</TD><TD>£198,933</TD><TD>£198,933</TD><TD>£181,487</TD><TD>£111,765</TD><TD>£111,765</TD><TD>£111,765</TD><TD>£1,923</TD></TR><TR><TD>Cat 2</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£381,738</TD><TD>£524,656</TD><TD>£224,656</TD><TD>£224,656</TD><TD>£189,151</TD><TD>£189,151</TD><TD>£81,738</TD><TD>£81,738</TD><TD>£81,738</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD></TR><TR><TD>Cat 3</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD></TR></TBODY></TABLE> Thu, 24 Nov 2022 14:12:09 GMT Darrin 2022-11-24T14:12:09Z Area graph -Power BI 101 https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2927319#M6271 <P>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.&nbsp; I want to be able to show total and drill down into each category if necessary.</P><P>&nbsp;</P><P>Darrin</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Category</TD><TD>01-Jan-22</TD><TD>01-Feb-22</TD><TD>########</TD><TD>01-Apr-22</TD><TD>01-May-22</TD><TD>01-Jun-22</TD><TD>01-Jul-22</TD><TD>01-Aug-22</TD><TD>01-Sep-22</TD><TD>01-Oct-22</TD><TD>01-Nov-22</TD><TD>01-Dec-22</TD><TD>01-Jan-23</TD><TD>01-Feb-23</TD><TD>01-Mar-23</TD><TD>01-Apr-23</TD><TD>01-May-23</TD></TR><TR><TD>Cat 1</TD><TD>£500,000</TD><TD>£569,722</TD><TD>£81,776</TD><TD>£113,583</TD><TD>£115,506</TD><TD>£153,297</TD><TD>£153,297</TD><TD>£170,743</TD><TD>£242,794</TD><TD>£230,740</TD><TD>£198,933</TD><TD>£198,933</TD><TD>£181,487</TD><TD>£111,765</TD><TD>£111,765</TD><TD>£111,765</TD><TD>£1,923</TD></TR><TR><TD>Cat 2</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£381,738</TD><TD>£524,656</TD><TD>£224,656</TD><TD>£224,656</TD><TD>£189,151</TD><TD>£189,151</TD><TD>£81,738</TD><TD>£81,738</TD><TD>£81,738</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD></TR><TR><TD>Cat 3</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£103,691</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD><TD>£0</TD></TR></TBODY></TABLE> Thu, 24 Nov 2022 14:12:09 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2927319#M6271 Darrin 2022-11-24T14:12:09Z Re: Area graph -Power BI 101 https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2930063#M6284 <P>This is straightforward once you have brought your data into a usable format (by unpivoting the date columns)</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_1-1669398126534.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/830058i5C53B1C24C22C059/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_1-1669398126534.png" alt="lbendlin_1-1669398126534.png" /></span></P> <P>see attached.</P> Fri, 25 Nov 2022 17:42:31 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2930063#M6284 lbendlin 2022-11-25T17:42:31Z Re: Area graph -Power BI 101 https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2932423#M6296 <P>Thats brilliant thanks!</P><P>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):</P><P>&nbsp;</P><P>Project 1, Cat 1....</P><P>Project 2 Cat 1...</P><P>Project 3 Cat 2...</P><P>Project 4 Cat 3...</P><P>Project 5 Cat 1...</P><P>....</P><P>....</P><P>&nbsp;</P><P>And also is it possible to deal with the even more complex scenario of:</P><P>&nbsp;</P><P>Project 1 Cat 1 High ....</P><P>Project 2 Cat 1 Low ...</P><P>Project 3 Cat 2 Current ...</P><P>&nbsp;</P><P>etc?</P><P>&nbsp;</P><P>&nbsp;</P><P>Sorry for asking!!!</P><P>&nbsp;</P><P>Darrin</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 28 Nov 2022 09:16:48 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2932423#M6296 Darrin 2022-11-28T09:16:48Z Re: Area graph -Power BI 101 https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2932865#M6298 <P>Please provide sanitized sample data that fully covers your issue.<BR />Please show the expected outcome based on the sample data you provided.</P> Mon, 28 Nov 2022 12:16:45 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Area-graph-Power-BI-101/m-p/2932865#M6298 lbendlin 2022-11-28T12:16:45Z