Forum Discussion

Lenin's avatar
Lenin
Frequent Visitor
9 years ago
Solved

Report Level Filter Based On Formula

Hi,      I have a table (TaskTimePhasedDataSet) that has time phased project data. The table measures project performance over time, akin to the "Earned Value Over time" report in Microsoft Project....
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Lenin,

    You may need to create measure to calculate SPI when the TimeByDay equals to Project Status Date, then create Line Chart using the measure. You can share sample data of your tables or PBIX file for us to analyze.

    Thanks,
    Lydia Zhang

Lenin's avatar
Lenin
Frequent Visitor
9 years ago

Hi Lydia,

              I was seeking to be able to show data on the line chart up to the "Project Status Date" which is set on my table. I wanted this to happen automatically i.e. when I select a project from my drop down the line chart only shows data up to the "Project Status Date".

 

Sorry if this is not clear.

 

Lenin

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Lenin,

You may need to create measure to calculate SPI when the TimeByDay equals to Project Status Date, then create Line Chart using the measure. You can share sample data of your tables or PBIX file for us to analyze.

Thanks,
Lydia Zhang