Forum Discussion

farina_dj's avatar
farina_dj
Regular Visitor
4 years ago

Advanced filter options from different source.

Hi Community, good day, I'm a bit stuck in a solution I need to produce for an odd situation. I'd like to ask your help to see if it's possible what I'm trying to do, please.   My main table is a...
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

farina_dj Can you just have 2 slicers, one for Event and one for Area?

  • farina_dj's avatar
    farina_dj
    Regular Visitor
    4 years ago

    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:

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      4 years ago

      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. 

      • farina_dj's avatar
        farina_dj
        Regular Visitor
        4 years ago

        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.