Forum Discussion

MarijeB's avatar
MarijeB
Frequent Visitor
1 year ago
Solved

Filter dynamically based on mutliple values

Hi, I'm new to PowerBI, but I managed to create my first report. There's only one thing I can't figure out, maybe someone here is willing to help me.   I'm using a dabase to manage upcoming events...
Need Help
Show and Tell
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    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

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi MarijeB You will have to use a calculated column for this could you please try these 
Create a calculated column in your table to handle the filtering logic:

 

FilterGroup = 
IF(
    'Table'[Identical] = TRUE(),
    'Table'[CombinedID],
    'Table'[ID]
)

 

Add the new FilterGroup column to a slicer in your report. It will display all unique IDs or groups.

This will do the dynamic filtering of all rows based on CombinedId Or Unique ID when an Id is selected
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance