Dynamic Currency Measure with Stacked Bar / Column / Pie Chart

[azurian]

Hi, 

I want to change the currency in PowerBI reports that customer choose. I am able to achieve using DAX formula in PowerBI and its properly working in Table / Card / Matrix visualizations.

Unfortunately, its not working with Stacked Bar / Column / Pie Chart as you see the below illustration.

It allows to drag and drop on the tooltips but not in values as you see here.

I am not sure whether Stacked Bar / Column / Pie Chart has limitations or expects columns / measures ONLY without any complex DAX formulas by design.

See attached image. Any help / suggestions would be appreciated.

[v-jiascu-msft]

Hi @azurian,

The result of the measure DynamicCurrency is a Text type. That's why we can't add it in the value field directly in some visuals. Please vote up these ideas: dynamic-data-labels, data-labels and data-label-alias.

Best Regards,

Dale