topic By Weekely Graph in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/By-Weekely-Graph/m-p/3781476#M9321 <P><SPAN>&nbsp;need to create a bar graph using the shipped amount and ordered amount, which should be like below.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curious_111_2-1711001266034.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1064116iD975CC381095E6FE/image-size/medium?v=v2&amp;px=400" role="button" title="curious_111_2-1711001266034.png" alt="curious_111_2-1711001266034.png" /></span></P><P>&nbsp;</P><P><SPAN>But when I am trying to achieve this I got graphs like below</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curious_111_1-1711001247777.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1064115i8E6C2F5FD3608809/image-size/medium?v=v2&amp;px=400" role="button" title="curious_111_1-1711001247777.png" alt="curious_111_1-1711001247777.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curious_111_3-1711001280666.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1064117i6C9D3DC846AA6293/image-size/medium?v=v2&amp;px=400" role="button" title="curious_111_3-1711001280666.png" alt="curious_111_3-1711001280666.png" /></span></P><P>I am not sure exactly how can I solve this. My date_table code is</P><P>&nbsp;</P><DIV><DIV><SPAN>Date_Table =</SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN>&nbsp;</SPAN><SPAN>_Table</SPAN><SPAN>=</SPAN></DIV><DIV><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>CALENDAR</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2013</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>24</SPAN><SPAN>),</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2014</SPAN><SPAN>,</SPAN><SPAN>2</SPAN><SPAN>,</SPAN><SPAN>31</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"Consecutive Week Number"</SPAN><SPAN>,</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>,</SPAN><SPAN>2</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; +&nbsp;</SPAN><SPAN>52</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; * (&nbsp;</SPAN><SPAN>YEAR</SPAN><SPAN>&nbsp;(&nbsp;</SPAN><SPAN>[Date]</SPAN><SPAN>&nbsp;) -&nbsp;</SPAN><SPAN>YEAR</SPAN><SPAN>&nbsp;(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2013</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>24</SPAN><SPAN>) ) ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"Week Number &amp; Year"</SPAN><SPAN>,</SPAN><SPAN>"W"</SPAN><SPAN>&nbsp;&amp;&nbsp;</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &amp;&nbsp;</SPAN><SPAN>" "</SPAN><SPAN>&nbsp;&amp;&nbsp;</SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"WeekYearNumber"</SPAN><SPAN>,</SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &amp;&nbsp;</SPAN><SPAN>100</SPAN><SPAN>&nbsp;+&nbsp;</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"MonthShortYear"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>,</SPAN><SPAN>"mmm-YYYY"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>_Table</SPAN></DIV></DIV><P>&nbsp;</P> Thu, 21 Mar 2024 06:08:20 GMT Anonymous 2024-03-21T06:08:20Z By Weekely Graph https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/By-Weekely-Graph/m-p/3781476#M9321 <P><SPAN>&nbsp;need to create a bar graph using the shipped amount and ordered amount, which should be like below.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curious_111_2-1711001266034.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1064116iD975CC381095E6FE/image-size/medium?v=v2&amp;px=400" role="button" title="curious_111_2-1711001266034.png" alt="curious_111_2-1711001266034.png" /></span></P><P>&nbsp;</P><P><SPAN>But when I am trying to achieve this I got graphs like below</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curious_111_1-1711001247777.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1064115i8E6C2F5FD3608809/image-size/medium?v=v2&amp;px=400" role="button" title="curious_111_1-1711001247777.png" alt="curious_111_1-1711001247777.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curious_111_3-1711001280666.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1064117i6C9D3DC846AA6293/image-size/medium?v=v2&amp;px=400" role="button" title="curious_111_3-1711001280666.png" alt="curious_111_3-1711001280666.png" /></span></P><P>I am not sure exactly how can I solve this. My date_table code is</P><P>&nbsp;</P><DIV><DIV><SPAN>Date_Table =</SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN>&nbsp;</SPAN><SPAN>_Table</SPAN><SPAN>=</SPAN></DIV><DIV><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>CALENDAR</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2013</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>24</SPAN><SPAN>),</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2014</SPAN><SPAN>,</SPAN><SPAN>2</SPAN><SPAN>,</SPAN><SPAN>31</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"Consecutive Week Number"</SPAN><SPAN>,</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>,</SPAN><SPAN>2</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; +&nbsp;</SPAN><SPAN>52</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; * (&nbsp;</SPAN><SPAN>YEAR</SPAN><SPAN>&nbsp;(&nbsp;</SPAN><SPAN>[Date]</SPAN><SPAN>&nbsp;) -&nbsp;</SPAN><SPAN>YEAR</SPAN><SPAN>&nbsp;(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2013</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>24</SPAN><SPAN>) ) ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"Week Number &amp; Year"</SPAN><SPAN>,</SPAN><SPAN>"W"</SPAN><SPAN>&nbsp;&amp;&nbsp;</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &amp;&nbsp;</SPAN><SPAN>" "</SPAN><SPAN>&nbsp;&amp;&nbsp;</SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"WeekYearNumber"</SPAN><SPAN>,</SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &amp;&nbsp;</SPAN><SPAN>100</SPAN><SPAN>&nbsp;+&nbsp;</SPAN><SPAN>WEEKNUM</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>"MonthShortYear"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>,</SPAN><SPAN>"mmm-YYYY"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>_Table</SPAN></DIV></DIV><P>&nbsp;</P> Thu, 21 Mar 2024 06:08:20 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/By-Weekely-Graph/m-p/3781476#M9321 Anonymous 2024-03-21T06:08:20Z