Format value works on the table, not in the graph

[Anonymous]

Hello,

I create a special format value and visible in the table when , for example, I use a special converter like as:
56.90 EUR/ML 

12.91 USD/GWh

those are Text data type, and obviously, works in the table.

But not in the charts, because needs Value format. So I show only
56.90
12.91 

but in another measure, because I must to remove format function.

Any idea how to append special chars in the charts?

thanks

[Gordonlilj]

Hi,

Have you tried using custom format in the model pane?

[Anonymous]

Hi, thank you @Gordonlilj 

I saw it, but "custom format" is not custom enough, because my format is envolving by another variable. Yes, I know, I didn't tell the detail.

here an example

tag	value	unit
A	56.90	EUR/MWh
B	90.10	GWh
C	71.10	USD/MWh
D	61.00	EUR/ML

I created measure "converter" and I apply it on the matrix table,  calculate and append the format.

When I do it for chart, obviously don't works. So, I transform the measure in value (instead text).

So, can't I manipulate this field?