Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@Anonymous , in data transformation/edit query mode, there in option split by delimiter
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |