Slicer is slicing data from another table.

[kasiaw29]

Hi all,

Having a really funny problem going on. I have a CRM report which is looking at sales vs. targets kind of data. 

We are looking at data coming from two tables where relationships are established based on person(*-*,both ways), region(*-*,signle from targets table to crm data),sector(*-*,single from targets table to crm data) and year(*-1)

I'm using simple bar charts as client values simplicity in data they want to compare (actual performace vs. target) and everything is looking really well, data is validated with the one on the database and can confirm it's matching the expected result.

Then slicing begins. I have slicers that for Year it was created, Region , Sector and Person - all from CRM data table.  When for example I slice it by Year i.e. I only want to see what was created in 2019 my targets are being sliced as well where this data shouln't get sliced at all as it's on a different table. So my card that displays e.g. sum of all tagets =1500 then gets sliced to e.g. 500 based on the slicer selection.

Has anyone ever had similar issue? 

Hope I made my issue clear enough. Any suggestions are appreciated. 

Thanks.

[v-danhe-msft]

Hi @kasiaw29 ,

Could you have checked if therer is any relationships between your two tables? For further help, I suggest you share your sample pbix file to have a test if possible.

Regards,

Daniel He

[kasiaw29]

Hello Daniel  @v-danhe-msft 

Thanks a lot for replying! Please see below. Can't unfortunately share the file as its connected to Oracle. 

Highlighted relationship is *-1 with a direction from 1 to *. 

Thanks,

Kasia