Blank Values in my graph

[Mikekhel1987]

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.

[v-jiascu-msft · Accepted solution]

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

[Mikekhel1987]

Hi Dale,

Thank you for helping me again. It works like magic! 

God Bless.

Regards,

Mike

[tjd]

Try filtering the categories on the y-xis to "Does not contain blanks".