Stacked bar chart with Pick measures format issue

dana — Wed, 11 Oct 2023 12:44:25 GMT

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!

topic Stacked bar chart with Pick measures format issue in App Development