I am trying to make a map of countries served by my team, with the countries listed below in multiple columns, along with a few KPI labels.

To show the list of countries, I created multiple sheets, each sheet filtered to show a few countries, say fifteen, placed the country dimension to row shelf, then arranging the sheets side by side in the dashboard.

This temporarily solves the issue, as for the time being, I just need to make the dashboard, save it as a pdf for my manager to use in a presentation..

But later, I will be publishing the dashboard live to Tableau server, where the below challenges will be present

New countries will come up (theoretically) and I would require the list to be updated.

Countries are shown, sorted alphabetically.

We might need to add, new columns/ increase the no of countries shown per column as new countries are added

Since by data is in SQL server, I created the below calc to generate column no (The countries available in my data are little different)

if LEFT([Country],1)>="A" AND LEFT([Country],1) <="C" THEN 1

ELSEIF LEFT([Country],1)>="D" AND LEFT([Country],1) <="J" THEN 2

ELSEIF LEFT([Country],1)>="K" AND LEFT([Country],2) <="RO" THEN 3

ELSEIF LEFT([Country],2)>="RU" AND LEFT([Country],1) <="T" THEN 4

ELSE 5

END

The above calc gives the below output; this is working great.

Only challenge would be to re-distribute the countries, when a new country is added to the data (for eg, I don't have Ecuador in the data now), so that all columns have the same no of countries. Anyhow, this is not a big concern for me now.