Forum Discussion

Markando's avatar
Markando
Frequent Visitor
8 years ago

Avoid travelling one specific filter between two tables

Hi! Ive got two tables on my report with customer sales   The first one is a list of sales during current month. The table itself is filtered by a calculated column I have in my datetable (Curre...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Markando,

 

I tested on my side with below sample tables.

 

I created two table visual whose data are both from Table1, then, I add a visual level filter for one of the visual.

 

From above screenshot, the filter applied to first visual won't affect the second one.

 

In your scenario, please check whether you applied any filter to second table, including slicer, visual/report/page level filters. If possible, provide more details so that I can try to replicate your scenario.

 

Regards,

Yuliana Gu

  • Markando's avatar
    Markando
    Frequent Visitor
    8 years ago

    Hi V-yulgu-msft!

    Thanks for your response

     

    See attachment for an example where i have replicated the scenario. The tables look the same so its kinda wierd, but probably because I use "real" dates and Power BI then think its smart to keep the filter. 

     

    https://ufile.io/fn83h