Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create Progress Tacker

Hello, I am fairly new to PowerBI and am wondering if the following is possible. I have a list of projects with their start and end dates and am looking to create a bar chart tracker that can shows t...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi Anonymous 

     

    Download sample PBIX file with the following data/chart

     

    Using a measure like this will give you what you need by Week Number.

    Active Projects By WeekNum = CALCULATE(COUNTROWS('Data'), FILTER(ALL('Data'), WEEKNUM('Data'[Project Start Date],1) <= SELECTEDVALUE(DateTable[WeekNumber]) && WEEKNUM('Data'[Project End Date],1) >= SELECTEDVALUE('DateTable'[WeekNumber])))

     

    This is using the Week Number form the DateTable.  See PBIX file above.

     

    Regards

     

    Phil

     

     

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi Anonymous 

 

Download sample PBIX file with the following data/chart

 

Using a measure like this will give you what you need by Week Number.

Active Projects By WeekNum = CALCULATE(COUNTROWS('Data'), FILTER(ALL('Data'), WEEKNUM('Data'[Project Start Date],1) <= SELECTEDVALUE(DateTable[WeekNumber]) && WEEKNUM('Data'[Project End Date],1) >= SELECTEDVALUE('DateTable'[WeekNumber])))

 

This is using the Week Number form the DateTable.  See PBIX file above.

 

Regards

 

Phil

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you PhilipTreacy this is exactly what I needed!