Forum Discussion
Australia map not working correctly
Hi quavaq,
No. What I meant was whether the Power BI map can recognise State-Country instead of State.
hi blaw
Ok I have found that you have to specify the country, otherwise it always assumes it is from the USA when there is something with the same name.
Hi guavaq,
I have tried with State and Country in the Location in the map, but the Legends I can only include state.
It still has no effect. Where do you specify the country in the map just to make sure I did not miss anything?
Hi blaw
I think that possibly things might be lost in translation.
What I have suggested is that you create a calculated column within your Power BI Model, that contains both the State and the Country. So this means that there will be a new column in your Power BI Model called "State-Country"
And this calculated column will be a combination of your State column with Australia at the end.
Once you then have this calculated column "State-Country" then change the data categorization to City or state, it should then show correctly.
Hi guavaq,
As I explain before I get my data from SSAS. I cannot create a new calculated column in Power BI.
Not to mention further about the data categorization as it is disable.
I can only create state-country in my dimension in SSAS.
If I specified the state-country as Georgraphy - 'State' in the data type, whether the map in Power BI recognise it as the state in Australia.
I have arlready tried filter out the country to Australia.
Thanks guavaq for your replies. I actually learn more about Power BI eventhough this issue is not resolved.
Will log this to Microsoft.