Forum Discussion
Graph's changing as you select different locations on Map (ESRI)
Hi Guys,
Im going to try my best to explain this i am really looking for some help. Im new to Power BI and im trying to work out how to input some data and link the company name (which is the same in different sheets) together so that when i click on a location on the map the graphs then change to the results of the company. For example i would like to click on Company A on the Map and then the graph to the side shows the sales from 2012 to 2018. However when try and do this it just inputs the graph with all of the companies and the results. I am trying to make it so only the company’s results that i click on populate the graph. I have tried to join the relationship between the company name in each sheet however i am getting this error.
So this is how the data is coming up at the moment and when i click on the location of the map the graph does not change.
I am trying to get it so when i click on the location on the map the data in the graph then changes to just shows for example the sales for that company over the last few years.
For example (sorry about the writing but i would like the graph to change and only show sales for the selected company)
Any help would be greatly appreciated.
CHeers!