Forum Discussion
relationship setup
Just to be clear. Only use fields from the middle tables (surrounded by the red rectangle) for your slicers and on the axis of your visuals.
Do not use ANY fields from the two tables with the red crosses in a slicer or on the axis of a visual. You can use numeric fields from these tables for measures etc.
Hi thanks for the suggestion, but doesn't seems to be working, look at my scrubbed pbix file below.
https://www.dropbox.com/s/kaqbg9fc8h3wpo1/testchecknew.pbix?dl=0
My issues starts while i filter for a specfic value in the region, could be any region and i realised that tables/charts, doesn't interact properly.
However it works with my filter for Account sector.
Do let me know, if there is way i can fix this, i must be doing something incredibly wrong.
thanks for taking time and suggesting any change
Got the file, so if I select Africa from the region slicer. what is the issue? I don't see any errors.
Right, you may not find the issue while selecting the region as africa, what you need to do is select the region Africa and then click on Outbound to americas & the result is weird, below is what i see
Sector Revenue View is Blank (No value is getting displayed)
Account sector view is blank
Inbound matrix/table is Blank
thus making me feel that, its not interacting with other Matrix & charts,
attach is the screenshot.