How can I change the formatting of the data values in the "Advanced Drill-Down Column Chart by ZoomCharts"

[scardenas]

I need to change the thousands separator,
Example
a value such as 105600 the default formatting displays 105,600
I would like the format to be 105.600

[SupportTeam]

@Aivis, please review this issue.

[scardenas]

Thank you very much

I await your response.

[SupportTeam]

Hi,

To change the thousands separator, you have to go to your computer settings and adjust your regional settings.

Afterwards, please use PowerBI Desktop to update the format for the field in your data model and then it should be reflected in the visual.

Thanks,
Janis

[scardenas]

Hi thanks,

the change of separator of thousands in the configuration of the computer was realized, nevertheless the graph continues showing the separator of thousands with commas.

attached image

[SupportTeam]

Hi,

Did you try to reload the power bi application after changing the regional settings?

Thanks,
Janis

[scardenas]

Hi

Yes, the change of the regional configuration was made and the Power Bi was reloaded.

Other graphs have been tried and this one shows the information with the separation of decimals in (.)
this graphic no.

Attached image of another image.

[SupportTeam]

Hi,

Please download new version the Advanced Drill-Down Column chart by ZoomCharts at zoomcharts.com

Now, it should support the locale that your are using. Note, for the web-based power-bi it would detect the locale automatically. For PowerBI Desktop edition - you should update the locale under options->regional settings.

Note, customized locale settings are not supported.

Please let me know if this addresses your issue.

Thanks,
Janis

[scardenas]

Hi Janis.

Thanks,

download new version the Advanced Drill-Down Column chart by ZoomCharts at zoomcharts.com

This did not solve the problem

In regional configuration I have the thousands separator in (.), However when loading the data to the graph it converts the thousand separator into (,)

I attach images of the data and the graph.

[SupportTeam]

Hi,

Custom regional settings won't work, as such information is not provided to the visuals. However, you can choose a different "country" that matches your necessary format. So for "." being thousands separator and "," being decimal separator.

Here is a list of a few options: https://docs.oracle.com/cd/E19455-01/806-0169/overview-9/index.html

It seems that if you set the regional settings to "Italian" (that should be done in Power BI desktop: here is how: http://community.powerbi.com/t5/Desktop/Locale-settings-not-working/m-p/50306#M20126), formatting should match your requirements. Can you try this approach?

Thanks,
Janis

[scardenas]

Hi Janis,

Thank you very muchfor your help.

The configuration indicated in power bi desktop for the report I am using does not apply since it is connected to an Analysis services cube and this configuration is disabled.

adjunto imagen

The default configuration that we have in the Analysis services cube is thousands separator in (.)

I send two examples of graphs within the report with the same data, showing that the drawback is generated with the graph of
Advanced Drill-Down Column Chart by ZoomCharts

graphic
Advanced Drill-Down Column Chart by ZoomCharts

Power bi graphic with the same information

[SupportTeam]

We are reviewing the problem with Microsoft team.

Janis

[asamah_shad]

Hi,

is there any progress on that?

Thanks,