Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Total Sum by Column (Matrix)

Created a gantt chart using matrix. I want to display the row total count with value for each date. Below is the image on the table i've been working out, together with the formula that I used to dis...
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi ,

     

    Please refer to the sample pbix:

     


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

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Also, refer my attempt to use Matrix as visual as project plan

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sure, attached link here is the sample pbi & the expected output. Lemme know if you have the solution. Thanks!

 

Sample PBI & Expected Output 

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    Hi ,

     

    Please refer to the sample pbix:

     


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