Forum Discussion

PBIbeginner's avatar
PBIbeginner
New Member
8 years ago

Currency division by thousand

working in connection with Direct Query - How to reflect the Currency amount rounded in thousands? E.g. €1,000,000 reflected in the PBI sheet as €,1000 . We need it in the visibility of the figures.
Do we need any Division Formula here?

1 Reply

  • jthomson's avatar
    jthomson
    Icon for Solution Sage rankSolution Sage

    You should be able to select how the information is displayed for a given visual by clicking on the formatting options on it, then altering the display units on the data label tab.

     

    There's a bunch of good stuff on these forums if you've searched around, you've made four new threads in half an hour - try looking to see if your question's already been answered before asking first!