Get name from id on a chart

Hello, how can I get the name of my suppliers from their ID’s, to display their names within the chart ?
My chart is based on a table that references turnovers, and suppliers are recorded within another “suppliers table” (and in my “turnover table” suppliers are referenced by their id’s). See below :

I managed to get a formula but then the display is missing in the chart :
Capture d'écran 2024-07-17 192505
Capture d'écran 2024-07-17 192512