https://community.fabric.microsoft.com/t5/Developer/Column-Chart-with-last-year-summary/m-p/3147656#M41879 <P>You would need to create summary tables and then union them.&nbsp; Then you would use a line and clustered chart.&nbsp;&nbsp;</P> Wed, 22 Mar 2023 15:47:33 GMT BrianConnelly 2023-03-22T15:47:33Z https://community.fabric.microsoft.com/t5/Developer/Column-Chart-with-last-year-summary/m-p/3147634#M41878 <P>hello, I would like to create a chart like the one below that shows:</P><P>the EoY summary for last year (2022)</P><P>and shows current year month by month,</P><P>Lines are cumulative values, please let me know if there are any ideas.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PatCreator_0-1679499282575.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/891170iB3E66AC2EAB8D843/image-size/medium?v=v2&amp;px=400" role="button" title="PatCreator_0-1679499282575.png" alt="PatCreator_0-1679499282575.png" /></span></P><P>&nbsp;</P> Wed, 22 Mar 2023 15:38:24 GMT https://community.fabric.microsoft.com/t5/Developer/Column-Chart-with-last-year-summary/m-p/3147634#M41878 PatCreator 2023-03-22T15:38:24Z https://community.fabric.microsoft.com/t5/Developer/Column-Chart-with-last-year-summary/m-p/3147656#M41879 <P>You would need to create summary tables and then union them.&nbsp; Then you would use a line and clustered chart.&nbsp;&nbsp;</P> Wed, 22 Mar 2023 15:47:33 GMT https://community.fabric.microsoft.com/t5/Developer/Column-Chart-with-last-year-summary/m-p/3147656#M41879 BrianConnelly 2023-03-22T15:47:33Z