Forum Discussion
Project Summary Subtasks Matrix
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.Regards,
Xiaoxin Sheng
Hey Anonymous ,
you should be able to solve that with a sort by column for each column:
https://radacad.com/sort-by-column-in-power-bi
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
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.
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.Regards,
Xiaoxin Sheng