Forum Discussion
Creating Visualizations not showing all data
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.
5 Replies
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!
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
Do you have a relationship set up between your Sales and Geography tables?
Yes I do. they are connected via ZipCountry.
And are you certain the values of ZipCountry in Sales have exact matches in Geography?
