Forum Discussion

kgilmore33's avatar
kgilmore33
Regular Visitor
7 years ago
Solved

Need to select different tables based on month

We have a SQL DB in Azure.  The application we use stores daily history records in tables organized by month.. so it creates a new table every month.  Fields are identical for each month, only the ta...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi kgilmore33 ,

     

    Slicer cannot filter the loaded datasets. If you want to load dataset dynamically based on selection, you could consider query parameters.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi kgilmore33 ,

 

Slicer cannot filter the loaded datasets. If you want to load dataset dynamically based on selection, you could consider query parameters.

 

Best regards,

Yuliana Gu