Custom Y axis stacked chart

Hi everyone ,

I'm Trying to create a chart like the next one 100% stacked bar chart with the total amount of a calculation in parenthesis

so the column name will be COUNTRY (CALCULATION)

I have tried several ways  but not able to change the Y axis in power bi  to the calculated field just created ,

Labels_country =

var country_name=

SELECTEDVALUE('PRD services_fact'[location_country])

var value_name =

FORMAT([Disct_instanceid],"#,##0")

VAR final_label=

country_name&" ("&value_name&" )"

RETURN final_label

 

It show properly on a table but not able to change the Y axis of the stacked chart to this calculation

Labels_country , as reference below is a table on how it would look like the final result of the y axis

as Labels_country

 

But in the chart I am just able to use location country

 

Thanks in advance for your help