Excel 3D Maps Data Card - format field to integer value

Question

Link to previously answered question

The post linked above answered my question on why the data is incorrectly displayed, but the solution did not describe the steps to resolve.

Looking for guidance on this because I am experiencing a similar issue and cannot resolve on my own.

Answer 1

Hi there,

Apologies if I was unclear with my request. I understand that currency format is not supported in 3D maps of Excel. However, the stated solution in the linked post was to convert the value to integer value in order to achieve a similar format.

I would like to know the necessary steps needed to convert my current value to integer value.

Thanks!

*Update: I was able to resolve the issue to successfully convert my values into integer values. I've found that if your dataset contains decimals then the value will be displayed in the unformatted style with all the preceding decimals.

In order to resolve, I had to use the formula =Trunc( ) to shorten the numbers to no longer contain decimal values and this corrected the issue. I'm certain that =round would also have the same result.

Answer 2

Update: Glad to hear that you had resolve your issue.

You can find the customzie data card from Layer Options>Data Card. But there is still no way to change the number format.

You should round the data at data source side before your create 3D map.

Answer 3

As the previous thread said, the value cannot be formatted as currency in 3D Map Data Card.

You may send feedback to Microsoft. Microsoft will collect the information and keep improvement of their product.

Send feedback to Microsoft with the Feedback Hub app - Microsoft Support