Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI Chart for Project Status

Hi All I need a critical help. I tried alot to create a chart for Project status count based no of activities .I have a dummy data and output expected as below Project ID Task Name Activity Sta...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Seems like:

Project Status Measure = 
  VAR __LastDate = MAX('Table'[AssignedPlanned])
  VAR __Status = MAXX(FILTER('Table',[Assigned Planned] = __LastDate),[Activity Status])
RETURN
  __Status

This will get you your table. For the graphic, you will have to use a disconnected table of your status values. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This is based on Planned Start or Planned Finish? Can we set around the logic with %Complete.