topic Re: Line Chart visualization based on Avg. Price per year and duration of contract in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1989930#M44003 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="109818" data-lia-user-login="mussaenda" class="lia-mention lia-mention-user">mussaenda</a>&nbsp;</P><P>Thanks a lot... It helped us to solve major challenge we had and kill alternative approach used which was very time consuming. Post implementation of that solution, we came across a scenario where we have some projects with values split by year and some consolidated ... See example below. Is it possible to generate same visualisation when you have some projects captured as one line and some in multiple lines with unique line value</P><P>&nbsp;</P><P>Visualisation we are trying to achieve is one by contract start year and one based on solution you already provided</P><TABLE><TBODY><TR><TD>Project Name</TD><TD>Contract Start Date</TD><TD>Contract End Date</TD><TD>Contract Term (Years)</TD><TD>Avg. Price per year</TD></TR><TR><TD>Project A</TD><TD>31/03/2021</TD><TD>31/03/2026</TD><TD>5</TD><TD>40000</TD></TR><TR><TD>Project B</TD><TD>25/11/2021</TD><TD>24/11/2026</TD><TD>5</TD><TD>42000</TD></TR><TR><TD>Project C</TD><TD>25/04/2023</TD><TD>24/04/2024</TD><TD>20</TD><TD>50000</TD></TR><TR><TD>Project C</TD><TD>24/04/2024</TD><TD>24/04/2025</TD><TD>20</TD><TD>51000</TD></TR><TR><TD>Project C</TD><TD>24/04/2025</TD><TD>24/04/2026</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2026</TD><TD>24/04/2027</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2027</TD><TD>24/04/2028</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2028</TD><TD>24/04/2029</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2029</TD><TD>24/04/2030</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2030</TD><TD>24/04/2031</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2031</TD><TD>24/04/2032</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2032</TD><TD>24/04/2033</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2033</TD><TD>24/04/2034</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2034</TD><TD>24/04/2035</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2035</TD><TD>24/04/2036</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2036</TD><TD>24/04/2037</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2037</TD><TD>24/04/2038</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2038</TD><TD>24/04/2039</TD><TD>20</TD><TD>66000</TD></TR><TR><TD>Project C</TD><TD>24/04/2039</TD><TD>24/04/2040</TD><TD>20</TD><TD>66000</TD></TR><TR><TD>Project C</TD><TD>24/04/2040</TD><TD>24/04/2041</TD><TD>20</TD><TD>67000</TD></TR><TR><TD>Project C</TD><TD>24/04/2041</TD><TD>24/04/2042</TD><TD>20</TD><TD>67000</TD></TR><TR><TD>Project C</TD><TD>24/04/2042</TD><TD>24/04/2043</TD><TD>20</TD><TD>67000</TD></TR><TR><TD>Project D</TD><TD>31/03/2021</TD><TD>31/03/2026</TD><TD>5</TD><TD>53000</TD></TR><TR><TD>Project E</TD><TD>01/12/2021</TD><TD>01/12/2022</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2022</TD><TD>01/12/2023</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>02/12/2021</TD><TD>01/12/2024</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2024</TD><TD>01/12/2025</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>03/12/2021</TD><TD>01/12/2026</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2026</TD><TD>01/12/2027</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>04/12/2021</TD><TD>01/12/2028</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2028</TD><TD>01/12/2029</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>05/12/2021</TD><TD>01/12/2030</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2030</TD><TD>01/12/2031</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>06/12/2021</TD><TD>01/12/2032</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2032</TD><TD>01/12/2033</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>07/12/2021</TD><TD>01/12/2034</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2034</TD><TD>01/12/2035</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>08/12/2021</TD><TD>01/12/2036</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2036</TD><TD>01/12/2037</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>09/12/2021</TD><TD>01/12/2038</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2038</TD><TD>01/12/2039</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>10/12/2021</TD><TD>01/12/2040</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2040</TD><TD>01/12/2041</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR></TBODY></TABLE> Fri, 30 Jul 2021 14:58:53 GMT AVS218 2021-07-30T14:58:53Z Line Chart visualization based on Avg. Price per year and duration of contract https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1957803#M42755 <P>Hi All,</P><P>&nbsp;</P><P><STRONG>End Solution Expected:</STRONG> I want to show Avg Price on Line chart for each project based on duration of contract<img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><STRONG>Fields I have as per below sample table</STRONG></P><TABLE border="1"><TBODY><TR><TD>Project Name</TD><TD>Avg. Price per Year</TD><TD>Total Contract Year</TD></TR><TR><TD><P>Project a</P></TD><TD>£ 20000</TD><TD>20</TD></TR><TR><TD>Project b</TD><TD>£ 30000</TD><TD>15</TD></TR><TR><TD>Project c</TD><TD>£ 45000</TD><TD>25</TD></TR><TR><TD>Project d</TD><TD>£ 65000</TD><TD>20</TD></TR><TR><TD>Project e</TD><TD>£ 25000</TD><TD>12</TD></TR><TR><TD>Project n</TD><TD>£ 35000</TD><TD>15</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>Any idea how to achieve above graphical representation based on these three fields</STRONG></P> Wed, 14 Jul 2021 15:32:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1957803#M42755 AVS218 2021-07-14T15:32:36Z Re: Line Chart visualization based on Avg. Price per year and duration of contract https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1977301#M43555 <P>Your sample data is missing the date/year column.</P> Sat, 24 Jul 2021 21:18:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1977301#M43555 lbendlin 2021-07-24T21:18:58Z Re: Line Chart visualization based on Avg. Price per year and duration of contract https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1977434#M43562 <P>Apologies I missed on that... Data will look like below and I have to consider Contract Start Date as Year 1 and then build on that based on Total Contract Duration. i.e. for Project A Contract Start Year as per date is 2019 and duration is 20 years. so my line chart should display £20k price from 2019 to 2039 and so on for other projects.&nbsp;</P><P>&nbsp;</P><P>Eventually we would like to visualize in two ways one displayed in my previous message and one which will show how much all projects cumulatively earn revenue in a specific year e.g. 2025</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><P>Project Name</P></TD><TD>Avg. Price per Year</TD><TD>Contract Start Date</TD><TD>Total Contract Duration</TD></TR><TR><TD><P>Project a</P></TD><TD>£ 20000</TD><TD>20/07/2019</TD><TD>20</TD></TR><TR><TD>Project b</TD><TD>£ 30000</TD><TD>20/01/2020</TD><TD>15</TD></TR><TR><TD>Project c</TD><TD>£ 45000</TD><TD>20/05/2020</TD><TD>25</TD></TR><TR><TD>Project d</TD><TD>£ 65000</TD><TD>25/10/2020</TD><TD>20</TD></TR><TR><TD>Project e</TD><TD>£ 25000</TD><TD>24/02/2021</TD><TD>12</TD></TR><TR><TD>Project n</TD><TD>£ 35000</TD><TD>22/05/2021</TD><TD>15</TD></TR></TBODY></TABLE> Sun, 25 Jul 2021 05:25:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1977434#M43562 AVS218 2021-07-25T05:25:30Z Re: Line Chart visualization based on Avg. Price per year and duration of contract https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1978434#M43587 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313448" data-lia-user-login="AVS218" class="lia-mention lia-mention-user">AVS218</a>&nbsp;,</P> <P>&nbsp;</P> <P>Based on the sample data you provided,&nbsp;</P> <P>please see the attached file.</P> <P>&nbsp;</P> <P>The result is based on the expected output you provided.</P> <P><img /></P> <P>&nbsp;</P> <P>Hope this idea helps.</P> Mon, 26 Jul 2021 06:25:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1978434#M43587 mussaenda 2021-07-26T06:25:54Z Re: Line Chart visualization based on Avg. Price per year and duration of contract https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1979989#M43638 <P>Super thanks for the solution. Really Appreciate it. It helped sort out main issue and gave us endless possibility</P> Mon, 26 Jul 2021 16:37:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1979989#M43638 AVS218 2021-07-26T16:37:34Z Re: Line Chart visualization based on Avg. Price per year and duration of contract https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1989930#M44003 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="109818" data-lia-user-login="mussaenda" class="lia-mention lia-mention-user">mussaenda</a>&nbsp;</P><P>Thanks a lot... It helped us to solve major challenge we had and kill alternative approach used which was very time consuming. Post implementation of that solution, we came across a scenario where we have some projects with values split by year and some consolidated ... See example below. Is it possible to generate same visualisation when you have some projects captured as one line and some in multiple lines with unique line value</P><P>&nbsp;</P><P>Visualisation we are trying to achieve is one by contract start year and one based on solution you already provided</P><TABLE><TBODY><TR><TD>Project Name</TD><TD>Contract Start Date</TD><TD>Contract End Date</TD><TD>Contract Term (Years)</TD><TD>Avg. Price per year</TD></TR><TR><TD>Project A</TD><TD>31/03/2021</TD><TD>31/03/2026</TD><TD>5</TD><TD>40000</TD></TR><TR><TD>Project B</TD><TD>25/11/2021</TD><TD>24/11/2026</TD><TD>5</TD><TD>42000</TD></TR><TR><TD>Project C</TD><TD>25/04/2023</TD><TD>24/04/2024</TD><TD>20</TD><TD>50000</TD></TR><TR><TD>Project C</TD><TD>24/04/2024</TD><TD>24/04/2025</TD><TD>20</TD><TD>51000</TD></TR><TR><TD>Project C</TD><TD>24/04/2025</TD><TD>24/04/2026</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2026</TD><TD>24/04/2027</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2027</TD><TD>24/04/2028</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2028</TD><TD>24/04/2029</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2029</TD><TD>24/04/2030</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2030</TD><TD>24/04/2031</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2031</TD><TD>24/04/2032</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2032</TD><TD>24/04/2033</TD><TD>20</TD><TD>60000</TD></TR><TR><TD>Project C</TD><TD>24/04/2033</TD><TD>24/04/2034</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2034</TD><TD>24/04/2035</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2035</TD><TD>24/04/2036</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2036</TD><TD>24/04/2037</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2037</TD><TD>24/04/2038</TD><TD>20</TD><TD>65000</TD></TR><TR><TD>Project C</TD><TD>24/04/2038</TD><TD>24/04/2039</TD><TD>20</TD><TD>66000</TD></TR><TR><TD>Project C</TD><TD>24/04/2039</TD><TD>24/04/2040</TD><TD>20</TD><TD>66000</TD></TR><TR><TD>Project C</TD><TD>24/04/2040</TD><TD>24/04/2041</TD><TD>20</TD><TD>67000</TD></TR><TR><TD>Project C</TD><TD>24/04/2041</TD><TD>24/04/2042</TD><TD>20</TD><TD>67000</TD></TR><TR><TD>Project C</TD><TD>24/04/2042</TD><TD>24/04/2043</TD><TD>20</TD><TD>67000</TD></TR><TR><TD>Project D</TD><TD>31/03/2021</TD><TD>31/03/2026</TD><TD>5</TD><TD>53000</TD></TR><TR><TD>Project E</TD><TD>01/12/2021</TD><TD>01/12/2022</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2022</TD><TD>01/12/2023</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>02/12/2021</TD><TD>01/12/2024</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2024</TD><TD>01/12/2025</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>03/12/2021</TD><TD>01/12/2026</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2026</TD><TD>01/12/2027</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>04/12/2021</TD><TD>01/12/2028</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2028</TD><TD>01/12/2029</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>05/12/2021</TD><TD>01/12/2030</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2030</TD><TD>01/12/2031</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>06/12/2021</TD><TD>01/12/2032</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2032</TD><TD>01/12/2033</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>07/12/2021</TD><TD>01/12/2034</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2034</TD><TD>01/12/2035</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>08/12/2021</TD><TD>01/12/2036</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2036</TD><TD>01/12/2037</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>09/12/2021</TD><TD>01/12/2038</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2038</TD><TD>01/12/2039</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>10/12/2021</TD><TD>01/12/2040</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project E</TD><TD>01/12/2040</TD><TD>01/12/2041</TD><TD>20</TD><TD>75000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR><TR><TD>Project F</TD><TD>01/12/2021</TD><TD>01/12/2041</TD><TD>20</TD><TD>59000</TD></TR></TBODY></TABLE> Fri, 30 Jul 2021 14:58:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Chart-visualization-based-on-Avg-Price-per-year-and/m-p/1989930#M44003 AVS218 2021-07-30T14:58:53Z