Forum Discussion

Dani_214's avatar
Dani_214
Frequent Visitor
8 years ago
Solved

Filtering two tables for different years

Hello,    I have a table with two measures; one displays the total for a selected time period (fiscal year and/or month), and the other displays the total for the same period of the previous year: ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    In the second table i.e. FY 2016, ensure that the measure you drag is the one you created for computing the previous year numbers.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Dani_214,

 

If I understand you correctly, you may need to edit the interactions between the Slicers and the two Tables(FY 2016/2017) under Format tab first:

 

1. Select the Slicer(FiscalYearDisplay) on the report.

 

2. Click Edit Interactions icon under Format tab.

 

 

3.  Click the None icon on the two Tables(FY 2016/2017).

 

 

Then you should be able to apply a visual level filter to each table to get the expected result in your scenario. :smileyhappy:

 

Regards