cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Working list/tasks report with multiple users

I have a list of tasks from our database that is a shared report in Teams.  User use this to find the next item to work on. (data is loaded)  

 

I thought I could just have a filter and have them uncheck the ones that have been work, but it doesnt pass/update the filter for other users.  I was hoping that there is away that it would update for all users so they know that one has been worked.

 

I really wish there was a way to do a check box, but I know thats not a possibility.

 

any advice?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Helper II
Helper II

Ok, I found a work around.

 

I created a measure for each matrix table (task list).  At that point I can assign someone to work on tasks 10-20.  I then created a range slicer based off of unique task number.  The user just will then need go to row 20, copy value of the unique task number, type in the unique task number for row 10 in the first range box then copy the unique task number (that you copied the value of) in the end range box. Vwa La, now they have a list of task 10-20 (now counted as 1-11).

 

As an addition, I kept a slicer on the left for the unique task number, so they can click them off as they are working them and know where they are on their personal list.

 

~Necissity is the mother of invention~

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @rjs2 ,

 

Check if the slicer works for you.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

No it doesnt, thats why I made the post.  The report is in Teams.  If there are two users using the report, the slicer doesnt auto update for the other user.  If it would pass thru and filter their report while they are working it, that would be sufficient, but it does not.

 

I need a way to let multiple users on the same report know they are working the item/task on the list and that it has been worked or in the process.

 

I wish there was a checkbox or something like that, or a drop down field for the report.  But I am guessing, if that did exsist, it would auto update for multiple users on the same report in Teams.

 

Any idea how to do that?  The filter option would work, if it would pass to other current users as well.  But it does not.

Helper II
Helper II

Ok, I found a work around.

 

I created a measure for each matrix table (task list).  At that point I can assign someone to work on tasks 10-20.  I then created a range slicer based off of unique task number.  The user just will then need go to row 20, copy value of the unique task number, type in the unique task number for row 10 in the first range box then copy the unique task number (that you copied the value of) in the end range box. Vwa La, now they have a list of task 10-20 (now counted as 1-11).

 

As an addition, I kept a slicer on the left for the unique task number, so they can click them off as they are working them and know where they are on their personal list.

 

~Necissity is the mother of invention~

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors