Show items with no data in a map

[Anonymous]

Hello everyone,

Is there a way to show items with no data in a Power BI map?

In my case, I have a map showing all the italian regions, and for each region there is a certain value of a field, that has a more intense color for the regions with more data available.

Instead for some regions, there are no data available: they shouldn't disappear from the map, but appear coloured of gray.

Thanks to anyone who will answer me.

[v-junyant-msft · Accepted solution]

Hi @Anonymous ,

Thanks for replies of Sergii24 and Alex87!

And @Anonymous , you can try this way:
Here I use several cities (not all cities) as sample data:
IndexCityCensus

1	Rome	1
2	Milan	2
3	Naples	3
4	Turin	4
5	Palermo	5
6	Genoa	6
7	Bologna	7
8	Florence	8
9	Bari	9
10	Catania	10
11	Verona	11
12	Venice	12
13	Messina	13
14	Padua	14
15	Prato	15
16	Trieste	16
17	Brescia	17
18	Parma	18
19	Taranto	19
20	Modena	20
21	Reggio Calabria	21
22	Reggio Emilia	22
23	Perugia	23
24	Ravenna	24
25	Livorno	25
26	Rimini	26
27	Cagliari	27
28	Foggia	28
29	Ferrara	29
30	Salerno	30
31	Latina	31
32	Giugliano in Campania	32
33	Monza	33
34	Sassari	34
35	Bergamo	35
36	Pescara	36
37	Trento	37
38	Forlì	38
39	Syracuse	39
40	Vicenza	40
41	Terni	41
42	Bolzano-Bozen	42
43	Piacenza	43
44	Novara	44
45	Ancona	45
46	Udine	46
47	Andria	47
48	Arezzo	48
49	Cesena	49
50	Pesaro	50
51	Lecce	51
52	Barletta	52
53	La Spezia	53
54	Alessandria	54
55	Pisa	55
56	Pistoia	56
57	Lucca	57
58	Guidonia Montecelio	58
59	Catanzaro	59
60	Treviso	60
61	Como	61
62	Brindisi	62
63	Busto Arsizio	63
64	Grosseto	64
66	Torre del Greco	66
65	Fiumicino	65
67	Marsala	67
68	Sesto San Giovanni	68
69	Varese	69
70	Pozzuoli	70
71	Cinisello Balsamo	71
72	Corigliano-Rossano	72
73	Aprilia	73
74	Asti	74
75	Casoria	75
76	Caserta	76
77	Ragusa	77
78	Carpi	78
79	Gela	79
80	Pavia	80
81	Cremona	81
82	Altamura	82
83	Imola	83
84	L’Aquila	84
85	Quartu Sant'Elena	85
86	Lamezia Terme	86
87	Massa	87
88	Viterbo	88
89	Potenza	89
90	Trapani	90
91	Cosenza	91
92	Pomezia	92
93	Castellammare di Stabia	93
94	Vigevano	94
95	Vittoria	95
96	Afragola	96
97	Viareggio	97
98	Carrara	98
99	Olbia	99
100	Matera	100
101	Fano	101
102	Legnano	102
103	Caltanissetta	103
104	Faenza	104
105	Savona	105
106	Crotone	106
107	Anzio	107
108	Acerra	108
109	Marano di Napoli	109
110	Molfetta	110
111	Cerignola	111
112	Benevento	112
113	Moncalieri	113
114	Cuneo	114
115	Agrigento	115
116	Foligno	116
117	Tivoli	117
118	Trani	118
119	Manfredonia	119
120	Siena
121	Bisceglie
122	Modica
123	Bitonto
124	Montesilvano
125	Sanremo
126	Gallarate
127	Bagheria
128	Avellino
129	Portici
130	Velletri
131	Teramo
132	Civitavecchia
133	Pordenone
134	Cava de' Tirreni
135	Rho
136	Acireale
137	Rovigo
138	Aversa
139	Mazara del Vallo
140	Ercolano

The first thing you need to be aware of is that even though some cities do not have available data, the names of these cities must exist in your datasheet, otherwise you will not be able to make these cities appear in the map.
Then create the Azure map with the Legend and Size blank:

Then set colors:

And the final output is as below:
City with data:

City witout data:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sergii24]

Hi @Anonymous, what type of map do you use? Below you can find an example of Filled Map for Italy. As you can see, when measure result is 0 the region is not removed but greyed out as one might expect.

If you still face the issue, please share pbix and describe in details the desired result.

Good luck with your project!

[Anonymous]

I'm using an Azure Map.

Yes, this is the result I would like to obtain

[Sergii24]

Please share a pbix file. In case of sensitive data, prepare a dummy sample where the issue persist. Or... use filled map visual 🙂

[Alex87]

Hello @Anonymous ,

Based on the details you've shared, I believe you can resolve this using the DAX function COALESCE. In your map's formula logic, the COALESCE function can provide a "default" value for regions lacking data. You could set a value slightly above zero, such as 0.000000001, to act as the baseline.

Best regards,

Alex