Forum Discussion
Filter dynamically based on mutliple values
Hi MarijeB ,
In SharePoint Lists, sometimes empty fields are a bit tricky (Blank vs Null), but not an issue.
Create a calculated column-
NormalizedGroupID =
IF(
ISBLANK([CombinedID]),
[ID],
[CombinedID]
)If CombinedID is blank → use the ID itself (it's a unique event, not grouped).
If CombinedID is filled → use the CombinedID (the common group ID for identical events).
Then, you set up your slicer based on this NormalizedGroupID, not the original ID!
Create a slicer visual and use NormalizedGroupID.Show other data (event info, time, location, etc.) based on this filter.
Now, if you click any event (whether original or identical), it will always show all events that belong to the same group!
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
Hi MarijeB ,
In SharePoint Lists, sometimes empty fields are a bit tricky (Blank vs Null), but not an issue.
Create a calculated column-
NormalizedGroupID =
IF(
ISBLANK([CombinedID]),
[ID],
[CombinedID]
)
If CombinedID is blank → use the ID itself (it's a unique event, not grouped).
If CombinedID is filled → use the CombinedID (the common group ID for identical events).
Then, you set up your slicer based on this NormalizedGroupID, not the original ID!
Create a slicer visual and use NormalizedGroupID.
Show other data (event info, time, location, etc.) based on this filter.
Now, if you click any event (whether original or identical), it will always show all events that belong to the same group!
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
