Creating Visualizations not showing all data

[jaytrice26]

When attempting to create a sales report to view revenue by country I can only revenue. I select country first and then revenue but it will only show the data for revenue.

[jaytrice26]

Well looks like that was my problem. I created a DAX query to create the ZipCountry column in both tables and it looks like I had extra spaces in one of the queries and not in the other. Thank you for your help!

[v-junyant-msft]

Hi @jaytrice26 ,

Have you solved your problem? If solved please mark the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,
Dino Tao

[CoreyP]

Do you have a relationship set up between your Sales and Geography tables?

[jaytrice26]

Yes I do. they are connected via ZipCountry.

[CoreyP]

And are you certain the values of ZipCountry in Sales have exact matches in Geography?