Forum Discussion
Current Phase
Hey y'all!
I'm currently working on a dashboard and i need support on this requirement.
The data i have structured as follows:
Project id, project name, phase, start date, end date.
And the project phases are planned till 2031.
The requirement is to have a bar chart that will calculate how many project are currently on what phase.
I thought of using a dax return the max start date and grouped by project id. But maybe i'll need to filter it to be < todays date?
I'm not really sure.
Can you please support me in this.
Thank you in advance,
1 Reply
You are working on a report, not a dashboard.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
