Stacked bar chart with Pick measures format issue

[dana]

Hi People,

I have a stacked bar chart with  dynamic measures.

The expression I use is:

Pick(Alternte_Dim1_Sort,
Num(Expression1,'#,##0'),
Num(Expression2,'#,##0%')
)

The format is defined as Auto.

The issue is that the format displayed is not displayed as expected.

For example, the percent is displayed as a decimal:

Any idea how to resolve this?

Thanks!