Forum Discussion
Child tasks indent into parent tasks.
hi,@bix
Here is an idea without drilldown, just visual indenting of the taskname, assumed you have a SortIndex within your datasource or can generate it.
You could calculate a column "IndentedTaskName" by prepending blanks depending on the level of the task.
In case you do not have the task-level information, maybe you could calculate that too: for example if ID starts with "F." then TaskLevel=0 otherwise TaskLevel = number of dots in ID
If you only have two levels as in your screenshot it would be even simpler:
TaskLevel = IF(Left('Tasks'[ID]; 2)= "F."; 0; 1)
IndentedTaskName = CONCATENATE(REPT(" "; [TaskLevel]); [TaskName])
Using conditional formatting, you could then style the tasks depending on TaskLevel.
I think the ID column of your screenshot does not contain the parent child relationship and sort order of tasks.
Best Regards,
Florian
Community Supporthi,@bix
You may try to use drill down function in the visual
for example:
Reference:https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down
Best Regards,
Lin
Hi Lin,
Thanks for reply. Yes, I am using visual level filters. But I want to indent child task under the parent task.
I tried the following method but no luck. If you have any other suggestion or idea, please let me know.
Thanks,
Salman
- v-lili6-msft
hi,@bix
we need more detail steps, Could you please show us the method you had tried and it is better to share some screenshot for us
Please share some data sample and the expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
Data source is cloud. Following is the screen shot, it's just simple table in power BI. Please assist me to use drill down function if is possible by drill down. You can consider me as beginner. I think this could be possible by scripting.
F.1 is a parent and 5 alpha-numaric ID are child. All parent tasks are in format of F.1
bi.
- DaFloDo
Resolver I
hi,@bix
Here is an idea without drilldown, just visual indenting of the taskname, assumed you have a SortIndex within your datasource or can generate it.
You could calculate a column "IndentedTaskName" by prepending blanks depending on the level of the task.
In case you do not have the task-level information, maybe you could calculate that too: for example if ID starts with "F." then TaskLevel=0 otherwise TaskLevel = number of dots in ID
If you only have two levels as in your screenshot it would be even simpler:
TaskLevel = IF(Left('Tasks'[ID]; 2)= "F."; 0; 1)
IndentedTaskName = CONCATENATE(REPT(" "; [TaskLevel]); [TaskName])
Using conditional formatting, you could then style the tasks depending on TaskLevel.
I think the ID column of your screenshot does not contain the parent child relationship and sort order of tasks.
Best Regards,
Florian