from Real time streaming dataset api's json format remove decimal places taken by default in number

[Anonymous]

I have created real time streaming dataset using api in power bi services. i have added few fields of type number. below the field we can see json format of created api. In that json format i can not able to modify the value of number datatype default from 98.6 to 98 only. As I am showing data on map visual tooltip it's showing the decimal places as 'value.00' ex '58,990.00' I want to remove this decial places from my real time streaming visual.

[ibarrau · Accepted solution]

Hi. The decimal option for the json is the only number option. You won't be able to change it. This is a modeling problem and not about the API. The only way I know to solve this is if you connect to the Power Bi Streaming Dataset with Power Bi Desktop. When connected, you can create measures. Those measures can be configured in formatting tab or by dax code in order to return an int or round number. That way you can make the numbers in the map integer instead of decimal.

Other way is changing the "Value Decimal Place" formatting option that some visualizations have. You can check an example here:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-card#format-a-card

Hope this helps,

Regards,