Forum Discussion
values are only displayed as thousands
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!
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,
3 Replies
Anonymous - Not entirely sure I understand, but multiply them by 1000?
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,
