Friday, October 12, 2018

Indented Schedule Tasks in Power BI #Tips

The other day, one of my US colleague asked our internal community for help in displaying project tasks in a table. The tricky part is that he wanted to display the task names indented as Microsoft Project would do. One of my fellow colleague (Jean Lieverman) working on Project Online and Power BI replied with the simplest yet super clever solution. 
I was so excited to see such a clever call that I wanted to share!

Here is the result
As you can see, we have here a nice table with indented tasks based on the outline level of the tasks.

The awesomeness is not necessarily in the visual result but in the way it has been built To get to that result, Jean created a new column (right click on the tasks table and add column) called "Task Padded" with the following formula:
Task Padded = REPT ( "     ", Tasks[TaskOutlineLevel] ) & Tasks[Task Name]

The formula will add as much tabulations as the outline number which references the level of indentation. Use that new column in your matrix or table and you are all set!

I hope that will help some people who might want to achieve the same.
Special Credit to Jean 👍
Take care.
Share this article :