Forum Discussion
Advanced filter options from different source.
Hi Greg_Deckler , thanks for the answer.
I might be missing something. A slicer needs a field to filter right? But as the relation is 1 - N, it's duplicating the events. If I go for making the relationship 1-1 by concatenating the areas in a event, I have that ugly filter like:
farina_dj I'm not understanding something. If the relationship is Events 1:N Areas and you create a slicer based on the Event column in Events and create a slicer based on the Area column of Areas then when you select an Event in that slicer then the Area slicer will only display areas for that Event.
Hi Greg_Deckler , sorry, no I didn't create a slicer for Event. Events is the table I'm analysing. I want to see events for the Customer X, events of the country Y, events with critical severity, events in the area Zone 1, etc. Events is the main table, EventID would be de PrimaryKey.
farina_dj Is your relationship bi-directional?
Greg_Deckler, No It's one EventID that can have many Areas related so a 1-N in the relationship between Event-Area.
Events has many others relationships with other tables, but just 1-1, only in this case of Area that the same EventID can happen in more than one Area.
Area has just this relation with Events.