Forum Discussion

deckamaha's avatar
deckamaha
Frequent Visitor
8 years ago
Solved

One filtering for all visuals

I have a question.   Suppose that i have alot of visuals with each table as each data source (oracle database tables).   Every table has each columns but with 1 columns with the same value and ty...
Need Help
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi deckamaha,

     

    Yes. As suggested by askelton, you could create a calendar table using CALENDAR function. Since each source table has a date column, please create a relationship between calendar table with each data table. Then, add date column from calendar table into slicer as selection options, when you specify a date in slicer, all visuals will be filtered together.

     

    Regards,
    Yuliana Gu

askelton's avatar
askelton
Resolver I
8 years ago

Make a date table with just unique values of those dates, and then make a relationship to the other tables.

  • deckamaha's avatar
    deckamaha
    Frequent Visitor
    8 years ago

    i don't quite understand by what you mean, so i have to make the relationships between the tables?

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi deckamaha,

       

      Yes. As suggested by askelton, you could create a calendar table using CALENDAR function. Since each source table has a date column, please create a relationship between calendar table with each data table. Then, add date column from calendar table into slicer as selection options, when you specify a date in slicer, all visuals will be filtered together.

       

      Regards,
      Yuliana Gu