Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Status Graph with Date Slicer

Hello,   I have data structured as follows:   Project Status Date of Status ProA started January 1, 2020 ProA testing March 13, 2020 ProA done April 2, 2020 ProB started ...
Need Help
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous I am thinking that you will need a disconnected table of your status codes (use an Enter Data query to enter or use:
    New Table = DISTINCT('Table'[Status]). Make sure there are no relationships to this table. Use the column created in this table as your legend. Then do something like the following (below). I mocked up the solution in the attached PBIX below sig. You want Page 18.

    Measure 18 = 
    VAR __Status = MAX('Table (18a)'[Status])
    VAR __Table = 
        ADDCOLUMNS(
            SUMMARIZE('Table (18)',[Project],"__MaxDate",MAX([Date of Status])),
            "__Status",MAXX(FILTER('Table (18)',[Date of Status]=[__MaxDate]),[Status])
        )
RETURN
    COUNTROWS(FILTER(__Table,[__Status]=__Status))

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous I am thinking that you will need a disconnected table of your status codes (use an Enter Data query to enter or use:
New Table = DISTINCT('Table'[Status]). Make sure there are no relationships to this table. Use the column created in this table as your legend. Then do something like the following (below). I mocked up the solution in the attached PBIX below sig. You want Page 18.

Measure 18 = 
    VAR __Status = MAX('Table (18a)'[Status])
    VAR __Table = 
        ADDCOLUMNS(
            SUMMARIZE('Table (18)',[Project],"__MaxDate",MAX([Date of Status])),
            "__Status",MAXX(FILTER('Table (18)',[Date of Status]=[__MaxDate]),[Status])
        )
RETURN
    COUNTROWS(FILTER(__Table,[__Status]=__Status))

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey thanks so much, this worked like a charm!