Forum Discussion
Data Scale
I am loading data into power BI through excel. My Data is in thousands. When I model them into chart's graphs etc it treats them as real numbers. What is the most efficient way to close this gap?
Maybe the easiest solution at this point is just to multiple my measures by 1000.
6 Replies
Hi rfreuden25,
I'm a little about your scenario, could you share some data or screenshots to describe your problems in more details?
Best Regards,
Cherry
For example: Revenues of "123.456" in my data set translates to $123,456.00. When I put that revenue number into say a bar chart, with the thousands scale, it shows as .123456 when in fact i want it to be 123.456.
Hi rfreuden25,
You could set the data Display Units under format like below.
If that still doesn't work, you could create a calcualted column to convert the 123456 to 123.456.
Column = 'Table'[Revenue]/1000
If you still need help, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
