Aggregate in tooltips

---

abukapsoun wrote:

Hi,

 

Need your expertise please,

I have the following case:

 

Country           Col1       Col2

Kenya              cs             ps

Kenya

Kenya

South Afr        ps

 

How can I when I hover over Kenya, the tooltips of the map displays cs, ps? 

I thought of just adding "cs, ps" in the same cell,saying Col1 Kenya, however if I create a filter and i press on ps, the ps in Col1 Kenya will not appear.

 

 

 

Many thanks 

 

 

---

abukapsoun

You can unpivot those two column at first.

 

Then create a measure as below and put it to the tooltip.

Measure = CONCATENATEX(FILTER(yourTable,yourTable[Value]<>""),yourTable[Value],",")