Forum Discussion
ank1997
4 years agoMicrosoft Employee
Creating a visual combing 3 different tables with similar data
Hi all, I have three tables that I want to combine and be able to create a visual on a map. How do I show all of the states with data? For some reason it is only pulling the location from a single ...
Anonymous
4 years agoNot applicable
Ideally, you should have a table with a column of all of the unique states, or more likely schools, and that column should have a one to many relationship with your fact table. That way, you are able to display and all states by filtering on the unique column.
--Nate