Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Project Summary Subtasks Matrix

I'm trying to use a matrix table to display projects, summary tasks and tasks in a drill down to expand and collapse at each level.  This is the project level from the project table.     ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I can't seem to get that to work.   The template I'm using is from the Microsoft project dashboard download.  If you look above the project image (from the Annual Schedule projecy) has summary/subtasks.  The Task Name is from the Project Task Table.  What column would I use to sort.    

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous,

I'd like to suggest you create a table with all value field names and an index column to setting custom sort order.

Custom Sorting in Power BI – Power BI & Excel are better together (excelnaccess.com)
After these steps, you can use the new table filed on matrix column, then you can write a measruer formula to get the current field value to lookup raw table field values.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup.com)

Regards,

Xiaoxin Sheng