Showing results for 
Search instead for 
Did you mean: 
bhuvanasundar Regular Visitor
Regular Visitor

Data modelling

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.

vikraman_mohan Frequent Visitor
Frequent Visitor

Re: Data modelling


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.




Helpful resources

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 169 members 1,873 guests
Please welcome our newest community members: