filter
32 TopicsFiltered data in Excel online are visible for all users
Hi all! Is it possible to see only my own filtered data in Excel Online? I mean when other users are working with the same book at that moment. At the moment, when someone filtered data - every one who edit the same document will see the same filters. I would like to know is it possible to avoid this. Thanks a lot for yours answers! Have a nice day!157KViews0likes14CommentsSheet View is generally available
Introducing Sheet View on Excel for the web, a new way of letting you create customized views in an Excel worksheet to sort and filter your data. You can filter to display only the records that are important to you without being affected by others collaborating in the document. All your cell level edits propagate through the file regardless of your view, so you can make all of your in-cell edits in your Sheet View, too.111KViews17likes68CommentsHow do I Find/Replace or Filter with exact words/characters?
Requirement 1: I want to be able to filter the cells to the letter "a" or "is" Requirement 2: I want to be able to Find and Replace the word "is" with should be Issue 2: When I search for "is", the words "list" and "display" show up and so the output is lshouldt and dshouldplay Is this possible without VBA? ThanksSolved46KViews0likes10CommentsPage properties not visible for filtering news webpart
We created a modern communication site to use as an intranet site. On that site we want to use two news webparts: one for corporate messages and one for news with lower importance. I want to use a filter one a custom (site) column in the site pages library: important messages, which is a yes/no type. This is one of a few custom site columns we created. None of the columns show up in the news webpart page properties filter. Only the title is available. Do we need to change something in the columns to make them show up?Solved33KViews0likes29Comments"Filter by" in sharepoint list returning no results?
Some users on my team are having an issue with a sharepoint list. they are in a specific view (not all items) and are trying to filter by a people/groups column. when they select a user to filter by, they get so results, or in some cases an "invalid statement, ResultCode:1" error. Typically if they refreshed the browser, or closed and reopened it, the filter would then work. I tried out clearing cache with one user, and that seemed to resolve the issue, but not sure if that is temporary fix or what. Anyone else seeing this issue?4KViews0likes3CommentsFilter chat activity that have a meeting recording?
I have a long list of chats like anybody else. Some might be just chit-chating with colleagues, others are group chats for past meetings. Some of the calls/meetings I participated in have been recorded by someone (not necesseraly by me) pressing the record button in Teams. These recordings are usually training sessions, and the recording is a good reference for later listening. I should have pinned those chats to easily find them, but now I have to find a few needle in a haystack of chats. Here is my problem statement: how can I easily filter my chat history to chats that are really meetings with a recording? I do not have a specific keyword unfortunately, I just want to see all my meetings that were recorded. I see that recorded meetings show in the chat a message with a video preview with the comment "Recorded by:". This is what I tried (did not work): * In Chat, Filter (Ctrl+Shift+F) by and I type by keyword "Recorded by:" but returns nothing * Search for "Recorded by:" in the top search bar on Teams. * In Microsoft Steams https://web.microsoftstream.com/ My Content > Meetings. I can only see meetings that I recorded, not meetings that I took place in that were recorded by others. My question is: how to filter in Teams / Chat meetings that have been recorded?Solved3.4KViews0likes1CommentLet us turn off vulgar word filters in dictation in Windows 10
The word filter in Windows 10 dictation is quite annoying, it blocks our ability to type anything we want. there needs to be a toggle to turn this setting off. there Is no word filter when we type something with keyboard, so it doesn't make sense to have word filter when we use speech to text. Please upvote this suggestion in the feedback hub app: https://aka.ms/AAajt7h3.3KViews1like3CommentsIs there an App to Search and Filter team members based on skills, attributes, etc.
I am currently exploring the possibility of using a Teams app or other programs to use as a data base for searching or filtering team members based on skills, certifications, knowledge, or even hobbies. Are there apps available that would work directly with teams? Similar programs that could be useful would be a more interactive organizational chart. Has anyone every heard of or used apps similar to this? Thanks in advance, Weston3.3KViews0likes4CommentsCross highlight when using direct query in PBI
The default behavior of Power BI is that every visual can filter any other visual. This is fine when the model is using import mode and all queries are very fast and cheap. With Direct Query we need to be much more careful about the number of queries generated and send to the backend source3.1KViews1like0Comments