Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Plot Column total in a line graph

Hi Experts

 

How would you polt in a line chart the total column values as shown below

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    According to your description, you want to create a line chart based on the total value of the columns in the matrix grouped according to the date values placed in the column fields in your matrix, right?

    If that's the case, you can try creating a line chart that places the date fields placed in the column fields in your matrix on the x-axis and the value fields in the matrix on the y-axis, and then you can achieve your needs.

    You can refer to the following posts that may be helpful to you:

    www.spguides.com

    Solved: Line chart with subtotals and total - Microsoft Power BI Community

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    According to your description, you want to create a line chart based on the total value of the columns in the matrix grouped according to the date values placed in the column fields in your matrix, right?

    If that's the case, you can try creating a line chart that places the date fields placed in the column fields in your matrix on the x-axis and the value fields in the matrix on the y-axis, and then you can achieve your needs.

    You can refer to the following posts that may be helpful to you:

    www.spguides.com

    Solved: Line chart with subtotals and total - Microsoft Power BI Community

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.