Culture awareness

Issue #63 closed
Former user created an issue

There are only a few places in the world that use a period to indicate the decimal place. An option to change decimal and thousands separator would certainly be appreciated.

Official response

  • Daniel Marsh-Patrick repo owner

    This issue will be resolved as follows:

    • We'll read the user's locale from the Power BI Service settings (or Desktop, if using that)
    • Additional settings will be added to the Tooltip menu:
      • # Samples Display Units / # Samples Decimal Places - will manage the formatting of the # Samples data point
      • Measure Display Units / Measure Decimal Placers - will manage formatting of all other data points pertaining to the measure
    • The formatting of the measure will still be taken from the user's configuration in the data model, with the exception of any display unit/precision overrides applied in the properties pane
    • The locale will then be applied, making sure that we still respect the user's choice for the measure format, but we can apply region-specific formatting.
    • This has also been applied to the Y-Axis ticks

    Here's an example of the new output:

    63-formatting.png

Comments (9)

  1. Daniel Marsh-Patrick repo owner

    Sure thing! It's on my list of things to do, so I'll use your ticket to implement. To manage your expectations, I'm busy with work for the next week but will start as soon as I can after that.

    My plan was to make this customisable for the tooltip values, as they currently derive from the y-axis (or measure) and they need to be decoupled.

    Can you confirm if there are any other specific parts of the visual that would benefit from configurable formats in a similar way? I'll do my best to include them here.

  2. Daniel Marsh-Patrick repo owner

    This issue will be resolved as follows:

    • We'll read the user's locale from the Power BI Service settings (or Desktop, if using that)
    • Additional settings will be added to the Tooltip menu:
      • # Samples Display Units / # Samples Decimal Places - will manage the formatting of the # Samples data point
      • Measure Display Units / Measure Decimal Placers - will manage formatting of all other data points pertaining to the measure
    • The formatting of the measure will still be taken from the user's configuration in the data model, with the exception of any display unit/precision overrides applied in the properties pane
    • The locale will then be applied, making sure that we still respect the user's choice for the measure format, but we can apply region-specific formatting.
    • This has also been applied to the Y-Axis ticks

    Here's an example of the new output:

    63-formatting.png

  3. Log in to comment