union formula column section error

[fiveone]

On the tooltip of a bubble chart I want to show both the name of the person and his seniority (=profile of candidate).

 I can show  seniority then name without problem

But as soon as I switch that order then the seniority just vanishes

 

The only way to bring it back is to put it in the tooltip section but then it shows at the end and it looks kind of stupid with the "First..." prefix.

Is that just a bug? what is its origin? Any known workaround?

[v-ljerr-msft · Accepted solution]

Hi @fiveone,

The only way to bring it back is to put it in the tooltip section but then it shows at the end and it looks kind of stupid with the "First..." prefix.

---

This is the default behavior currently. As only scalar value(like a measure) can be set to the "Tooltips" field, when a table column is set to the field, an aggregation will be applied to that column. In your scenario, the "First" aggregation is applied to your "FROFILE OF CANDIDATE" column by default, so there is a prefix of "First" show on the tooptips.

In this scenario, I would suggest you to create a new measure with a name you want, to return the value of "FROFILE OF CANDIDATE", then set the measure to the Tooltips field. The formula below is for your reference.

Profile_of_Candidate = FIRSTNONBLANK ( 'YourTableName'[FROFILE OF CANDIDATE], 1 )

Regards