How to specify what currency in DataGrid component

[Rob Clayton]

I have set the attribue for formatting a currency value as Format="C" in the  datagrid column, it is defaulting to GBP, whereas I need it as USD

                    <GridColumn Field=@nameof(BudgetRow.YearlyBudget) HeaderText="Yearly Budget" Width="150" Format="C"></GridColumn>

Please advise where I can specify the currency symbol for the datagrid component globally

[Prathap Senthil]

Hi Rob Clayton

Before proceeding with the reporting problem, we require some additional clarification from your end. Please share the below details to proceed further at our end.

• Could you clarify if you're using any specific localization features in your application? Localization can affect how currencies are formatted and displayed based on the user's locale or language preferences.
• What is the default language set in your system? Understanding the default language can provide insight into how currency symbols might be interpreted or displayed within your application.

Above-requested details will be very helpful in validating the reported query at our end and providing a solution as early as possible. Thank you for your understanding.

Regards,
Prathap S

[Rob Clayton]

Hi Prathap

It is an out the box Blazor web app .net 8 and no specifics set around any localization, we intend this application to be across other currencies, so would ideally like to specify at component level what currency to display.

Thanks

Rob

[Rob Clayton]

Also to mention, we require this for other components such as Pareto and Bar charts if you can also provide information on how to do this across the whole Syncfusion suite where financial data is involved

[Ilamathi Govindaraj]

Hi Rob Clayton,

We have analyzed your query regarding how to specify currency format in Pareto and Bar charts. We have created a sample Pareto and Bar chart, specifying the currency format in axis labels using the LabelFormat property. The data label is formatted the same as the axis label. We have attached a sample and a screenshot for your reference. Please check the code snippet below.

Code Snippet:

 

<ChartPrimaryYAxis ValueType="Syncfusion.Blazor.Charts.ValueType.Double" LabelFormat="C">

 

Screenshot:

Kindly revert us if you have any concerns.

Regards,

Ilamathi Govindaraj.

Attachment: ParetoAndBarChart_ca56d7ae.zip

[Rob Clayton]

Hi

It is not the currency format, but the currency. If I apply your code snippet it is still showing currency as £, how can I make it $?

Thanks

[Durga Gopalakrishnan]

Rob,

You can apply $ for axis labels using LabelFormat property. We have attached the modified sample for your reference. Please check with the below snippet and screenshot.

<SfChart>

    <ChartPrimaryYAxis LabelFormat="${value}"></ChartPrimaryYAxis>

</SfChart>

Sample : https://blazorplayground.syncfusion.com/rNrftILGpKVtszmx

Please revert us if you have any concerns.

[Rob Clayton]

Hi Durga,

Ok perfect - thanks for your help.

Rob

[Durga Gopalakrishnan]

Most welcome. Please get back to us if you need any further assistance. We are always happy in assisting you.