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 display the value in the table. 

This is my current Gantt Chart.


This is the output that I intended to do.

This is the formula that I used to get the value in the matrix :

column values =
VAR _startdate =
CALCULATE(
min('Task Tracker'[start date]),
all('Date'[Date])
)
var _enddate =
calculate(
max('Task Tracker'[expected end date]),all('Date'[Date])
)

var _status =
CALCULATE(max('Task Tracker'[current status]),all('Date'[Date]))
var _period =
min('Date'[Date]) >= _startdate && max('Date'[Date])<=_enddate

return
switch(
true(),
_period && _status = "Completed",1,
_period && _status = "In progress",2,
_period && _status = "Overdue",3,
_period && _status = "On Hold",4,
_period && _status = "Yet to start",5)

 

  • 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.

3 Replies

  • 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.