Forum Widgets
Latest Discussions
Unable to filter for multiple values in column
I am working in Power BI. I have Premium Capacity. Source Data is Excel. The source column has multiple values separated by semicolon. This shows my scenario from left to right: I am not able to return accurate results from the slicer if mulitple values are selected because the filter context only looks for a single value. I have tried: 1] Create a separate table for the slicer default values, create relationship to source data table with both one to one and many to one cardinality > the issue is the graphs from Population only show data where the column has a single value. It won't show the data where the column had multiple values or shows them all combined in their own bar. 2] create separate columns for Population so each value has its own column > the issue is the filter only looks at the first column. It can caused missed data if the value was in columns 2,3,4,5 There should be a way to deal with columns that have multiple values separated by semicolon, show only unique values in the slicer, but filter context needs to pass and return rows where any one or more slicer filter values is found in the one column in any order.
A new Tag Filter for a Sites Search shows the Term's Unique Id, not the Term's Text name
Hello, I have done a lot of searching on this issue but not having much luck, hoping that somebody out there can point me in the right direction. I have done the following on a SharePoint site; Navigated to the configure search settings (Microsoft Search) via the site's settings From there I went to "Verticals" and selected "All" Then "Edit" and "Filters" I then selected the filter where the property = tags and saved This property uses the Terms from my doc library column = Managed Metadata and I named the filter as "Knowledge tags" The Issue The filter shows in the Sites Vertical = "All", which is great and as expected However instead of showing the term, it is showing the terms unique identified. I can only see the term when I hover over the Id See image Does anyone know if; 1. This can be changed to display the term text name and not the unique ID - which is a poor user experience and.. 2. If so, how do I fix this? I will be very grateful for any support. Many thanks, Courtney
How many members have viewed a file in a SharePoint document library.
Hello Community, I would like to make a continuous evaluation of my files in SharePoint. For this purpose I am looking for the information how many people have viewed a certain file. How can I get this information through the SharePoint API? Unfortunately, I can't find the column that contains this information. Maybe this info is also stored in another system list? Thanks for your response Saintenr
