Dynamic Formatting & Custom Data Labels Not Working Consistently

[ericmarshall]

I have a chart with a "Total Outstanding" measure that uses dynamic formatting. The format has been set to [Selected Currency Formatting] (please see below DAX):

Selected Currency Formatting =

/*

Purpose:

Stores the corresponding currency formatting for the user's selected currency.

Notes:

Returns a currency format only when one currency has been selected in the current context.

*/

VAR SelectedCurrency = [Selected Currency]

VAR SelectedCurrencyFormatting =

SELECTCOLUMNS(

    FILTER(

        ExchangeRateSelection,

        ExchangeRateSelection[Currency ID] = SelectedCurrency

    ),

    "Currency Formatting",

    ExchangeRateSelection[Currency Formatting]

)

RETURN

IF(

    SelectedCurrencyFormatting = BLANK(),

    --Use dollar formatting if no formatting is returned by the SelectedCurrencyFormatting variable.

    "$#,###0.00;($#,###0.00);$0.00",

    SelectedCurrencyFormatting

)

For some reason when I drag the measure into a visual, the formatting on the total labels does not work consistently for every data bar:

Below is a screenshot of what the table of values referenced by the Selected Currency Formatting measure looks like:

Custom data labels are also not working correctly when using the dynamic formatting.

Both charts below use the same Total Outstanding measure referenced above. The chart on the left has custom data labels which only appear when the chart on the right is filtered, but per below, the custom formatting doesn't appear:

[Anonymous]

Hi @ericmarshall ,

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

Best regards.
Community Support Team_Caitlyn

[Josh_Boj]

Any updates here?