Forum Discussion

fiveone's avatar
fiveone
Helper II
9 years ago
Solved

union formula column section error

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 s...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

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

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

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

 

Regards