Forum Discussion
Power BI error
Hi,
I am not able to understand why i am getting a blank visulaziation when i select a particulare region from my dashboard, despite i have create the relationship between my tables.
Please find the scrubbed file below link
https://www.dropbox.com/s/kaqbg9fc8h3wpo1/testchecknew.pbix?dl=0
Error Screenshot
7 Replies
Hi,
Can anyone please help me, why in my dashboard when i select region, its not interacting with my sector revenue visualization and inbound matrix.
However it works perfectly well, when i clear off the filter. please find scrubbed PBI to check
https://www.dropbox.com/s/kaqbg9fc8h3wpo1/testchecknew.pbix?dl=0
Hi vjnvinod.
I've taken a look at your file and when selecting a region from the slicer component (dropdown list), all the visuals were filtered correcttly. See a capture below selecting "Africa" and (apparently) getting the data right.
Based on your capture, my guess is that you've had other selections made in visuals (it seems to be the case in the table in your capture), and these additional selections were not returning values for the others visuals.
Another suggestion would be to select the "cross filter direction" in all your relationships to "both". This sometimes creates strange behaviors while filtering data. To do that, double click all your relationships and look for the mentioned field.
Regards.
you nailed it correctly below
Based on your capture, my guess is that you've had other selections made in visuals (it seems to be the case in the table in your capture), and these additional selections were not returning values for the others visuals.
I did some testing on cross filters, but thats not helping at all.
Now the question would be how those additional selections can return values for other visuals?
please suggest? Can you check with your expertise, if something works for you?
If ALL the relationships are set to "Both" in the cross filter, the filters should work the way you expect. Are you sure the blank visuals are not related to not having data?
