Google Analytics Maps

[Requis]

Hello! I´m having some truble to set up the location of the map by States, the fields option only provides me Country option, 

Any idea of where can i configure the field Cities or states? 

im using the power BI online app from outlook 365, and i already link the analytics account to the power BI data source.

Thanks for any advice

David

[deanhummel]

Hi David

How did you connect your Google analytics account to the power BI data source online? I am using a mac and the online Get Data on PowerBI does not have an easy drop down... Thanks

[Baskar]

can u please share some sample data and output . it will helpfull to understand your prob .

If u have Hierarchy level like Country->State->City  in three different column , if ur answer is yes 

u have to do one thing click on state column and mark as a state "Data Category" like city too 

it will help u

[Requis]

Thanks for your replay, heres the image, i dont find a State-->City filter, any idea??

Thanks again!

[Baskar]

Do u have state or city column in your model ?

if u have pls drag this under country or put it in legend .

[Requis]

Hi!! no, i dont have it, the data is imported directly from Analytics (Google), i made some research and it seems than the API provides an already setup of data, this means than i have to work with the info im provided, 

Or perhaps im missing some setup or column on the model, 

Any advice? 

Thanks again, and Happy Holidays

David

[v-sihou-msft]

@Requis

Power BI just retrieve the given data directly when connecting third party serivce. If there's no City level metadata provided by Google Analytics, you can never drill down to this granularity. I suggest you consult Google Analytic support for more information.

Rergards,

Simon Hou