Forum Discussion
Getting Started and Trying to Move Fast
Your data model is wrong. You're welcome! :-]
Outline the structure of the data and explain what you mean by "goofish".
Can you explain what you mean by 'my data model is wrong?'
The structure of my data is the following: I have an excel spreadsheet with three tabs for portfolio, capital projects and building data. Within those tabs are datapoints that are specific to that tab as well as shared across the other two tabs.
What I mean by "goofish" was really supposed to be "goofy" but lets say I am under the building data that has every piece of information about that building. If I click on 'address', which is one of the columns, it shows up on the map. But if I add 'state" then everything disappears. Another example is that I have square footage for evey building but it keep calculating the total square footage of all of the buildings in the spreadsheet.
How can I import the spreadsheet in a manner where I can see where all of my buildings are on the map and have the ability to drill down into each building and see things like that building square footage, lease terms, and capital projects associated with that building. Note, all of that data is associated with a specific building in the spreadsheet.
Hi. If you import the three spreadsheets into Power BI Desktop you should see them appear as three tables in the Field List (right hand side as you look at the Report View). You should be able to create a map and drop State and Address into the 'Locations' part of the Field Well. Then you can drill down into specific states to see all the bulidings in that state. If you have a visual showing the total square footage, clicking on a specific building on the map should filter it to just the square footage of that building.
If you can give us some screenshots of your model (look at the Diagram View in the Desktop) and the visuals you have so far, it might help troubleshoot further.
thanks!
