Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver II
Resolver II

Slicer is slicing data from another table.

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. 






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.



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 *. 







Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.