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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi MarijeB ,

Based on the information, creating the new table with unique ID column.

Then, try using the following DAX formula and drag the measure to the Filters pane.

Measure = 
VAR _selected = SELECTEDVALUE('Table ID'[ID])
var _comnined = CALCULATE(MAX('Table'[CombinedID]), FILTER(ALL('Table'), 'Table'[ID] = _selected))
RETURN
IF(SELECTEDVALUE('Table'[Identical]) = "TRUE" && SELECTEDVALUE('Table'[CombinedID]) = _comnined, 1, 0)

The slicer filtering result is shown below.

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MarijeB's avatar
    MarijeB
    Frequent Visitor
    1 year ago

    Hi Anonymous , stll no luck. I'm probably doing something wrong.

    Whatever I try, any visual I apply the measure to turns blanc. Database- and columnnames and parameters are correct, I checked.

    First, I tried adding the measure to the new table I created for the ID, and when that didn't work to the alreay existing database. I also tried to apply the measure filter on the table visual. 

    Does it make a difference my source is a Sharepoint-list?