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

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