Forum Discussion
Blank Values in my graph
Hi All,
Can someone enlightened me. I have a graph that has a blank data. I don't know why there is a blank data in my graph, I don't have any blank from my source file. The source file comes from the MS Access. Any help would be greatly appriciated. below is the screenshot of the graph that has blank data.
Hi Mikekhel1987,
The root cause could be there are values in one side of the relationship but they don't exist in the other side. For example,
Table 1
Jack
Mark
Table 2
Jack 100
Mark 200
Mike 300
You can check it out.
Best Regards!
Dale
3 Replies
- tjd
Impactful Individual
Try filtering the categories on the y-xis to "Does not contain blanks".
v-jiascu-msftMicrosoft Employee
Hi Mikekhel1987,
The root cause could be there are values in one side of the relationship but they don't exist in the other side. For example,
Table 1
Jack
Mark
Table 2
Jack 100
Mark 200
Mike 300
You can check it out.
Best Regards!
Dale
Hi Dale,
Thank you for helping me again. It works like magic!
God Bless.
Regards,
Mike
