values are only displayed as thousands

[Anonymous]

Hey guys, I have the problem that my revenue values are only displayed as thousands in the visualization. How can I tell PowerBI that the values stored in the query are in the million range? Data type is decimal number. Thank you very much!

[Greg_Deckler]

@Anonymous - Not entirely sure I understand, but multiply them by 1000?

[Anonymous]

For example, the report has a target value of "12,5", but actually it is 12,500,000, right. Does this mean I have to convert it every time? If there is no function in which I can determine, leave the number at "12,5" and say in the scale it is "MIllions". You understand?

[ibarrau · Accepted solution]

Hi. If the number is 12,500,000 and it is displaying 12,5M then it might be a formatting option. Go to format in data labels and check for "display units". There you can pick what units you want for the visual. Example at point 2: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-card

Hope this helps

Regards,