Data modelling

[Anonymous]

Need your support here, 1/0/0 – which represents task is completed in the format of completed/pending/overdue, (it is not specific to 1, it will be other than 0).

If there is 1 there is one subtask for one task, if it is 2 then it means 2 subtasks assigned for one task. How to convert into status in dashboard? Also need to show number of subtasks.

[amitchandak]

@Anonymous , in data transformation/edit query mode, there in option split by delimiter

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Anonymous]

Hi, 

There are a lot of dashboard design that is possible here but to start with split the column in DB query or power query which is comfortable and write a conditional statement to get the desired output.

I would recommend to use a condition that says null or 0 to be closed and anything other than that as Concat("Open ", "Number of Tasks) to show the number of open tasks in a measure to make sure the heading dynamically changes.

This can also be provided as a slicer to the user to view tasks greater than 10 less than 5, etc.. The graphical representation of this might also be useful.

If you are displaying this in a table use it sort it by number of open tasks which will have an impact on the team to take necessary action to complete the open task.

Cheers

Vik