Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple filters on graph from different tables

Hello PBI professionnals,

 

I encountered a problem today, and can't find any way to fix it :

 

I have 2 tables of data, 1 show mobility and the other a value. Here are the 2 graphs from these 2 different tables :

graphs

I am using different slicers on those two raphs. But my slicers only work on the second one unfortunately :

Slicers

Both tables also have a "zone" column, with zones going from 1 to 5, a day column from monday to sunday and a date column.

 

I made a link between the date columns from my 2 tables, so the time slicer is working fine. However, I have trouble with the two remaining slicers on columns "zones" and "days". They only affect the second chart...

 

Any idea how to solve this problem please ?

 

Antoine

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Finally cracked it !

    I created a "Filter" column in both tables, concatenating all 3 values (time, zone and weekday).

    moved the relation between tables from the "time" columns to "filter" columns.

     

    So far, it seems to be working... 🙂

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Difficult to say. Generally, you would create a separate "Zone" table with distinct values for zones. Relate this to your other two tables. Use the zone from Zones table in your slicer.
  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi  Anonymous ,

     

    Select either of the other 2 slicers,then go to menu bar>"format">click "edit interaction":

     

    Check whether the 2 graphs are showing "filter",if showing "none",modify to "filter".

     

    If the above doesnt work,could you pls upload your .pbix file to onedrive business and share the link with us?

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello v-kelly-msft ,

       

      Here is the file : https://we.tl/t-tsbkLwWmXT 

       

      The problem is, data is coming from 2 different tables, that have the same column names. I do not know how to apply multiple filters (I already linked Time adding a relation, I can't do multiple relation with zone and day columns...)

       

      Thanks for your help !

      Regards,

       

      Antoine

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        Hi Anonymous ，

         

        Sorry but it cant be opened,can you upload it to onedrive business and share the link with us?

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!