Forum Discussion
relationship setup
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.
- Phil_Seamark8 years agoMicrosoft Employee
Hi vjnvinod
It's been overnight here and I'm back at work now. I will try to look at this later today. I suspect we might need to code a bit of DAX to get the result you are after.
- vjnvinod8 years agoImpactful Individual
- Phil_Seamark8 years agoMicrosoft Employee
Welcome back Sean :) , you've been quiet.
- vjnvinod8 years agoImpactful Individual
thanks, i look forward
but i am still wondering, if you unfilter everything, this interaction works
But you filter for a particular region, it doesn't, is that some bug in power BI?
ideally when i filter for a particular region, and click on any outbound or inbound of that matters, that particular value should get displayed in my other visuals.
- vjnvinod8 years agoImpactful Individual
Hi,
any feedback on this topic?
Appologise for chasing this out, just wanted to make sure we can do it, else we need to live with what is possible.
https://www.dropbox.com/s/kaqbg9fc8h3wpo1/testchecknew.pbix?dl=0
- vjnvinod8 years agoImpactful Individual
Can you let me know if you are able to help with this Topic.?
i have approached some of Power BI experts, but no one has the way to do it.
- Phil_Seamark8 years agoMicrosoft Employee
HI vjnvinod
This can be solved but will either mean some tricky DAX or duplicate tables. I would like to help but have been quite busy the last 2 weeks.
- vjnvinod8 years agoImpactful Individual
thanks Phil, it gives me some hope that it can be done.
will wait for your feedback.
Regards