Please share your twbx workbook with the data so we can better see what is going on
What is the smallest geographical unit in your marks card?
Maps will default to the smallest geographical unit. If your marks card looks something like this:
...and you only want countries filled, remove Region, State, and City. One click on the Country pill should do the trick.
Good luck! --Michael
Please find attached, workbook and excel file which I'm using.
Thanks for the reply.
I'm using % range as color in Dashboard. Please find attached, dummy dashboard and excel file which I'm using.
see below - you have 2 issues -
1 your are plotting Department not Country
and in your data all the US data points have their "City" name in the country and department field - it should be US in country then plot country
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
The problem is your department is actually not a geo role, it is the combination of country, state and maybe city as well.
What I think you could do is to use dual axis and duplicate department and set up the geo role as either state or city based on your own thoughts.
I take state/province role as example below
1st, duplicate the department as new dimension
2nd, edit the location by mapping department to a state and use dual axis
I just did two in the sample below
Hope this can give you some ideas. An updated workbook attached for your reference.
Dummy_v10.2.twbx 187.2 KB
Thanks a lot Zhouyi