Formatting measures in Table to nearest $100K

[Anonymous]

Hi 

In a Card viz I can format a measure as "Millions", "Decimal Places" = 1 (see Rounded to nearest 100K) 

so $23,130,1000  is displayed as  $23.1M 

How do I acheive the same format for a measure in a table?   

Closest I have come is using  : Measure = FORMAT ([Budgets.],"$##,#, M")  but that produces 23,130 K 

Cheers

[v-chuncz-msft · Accepted solution]

@Anonymous,

See Display units and precision control for table & matrix columns in Power BI Desktop March Feature Summary.

[ChrisMendoza]

Hello @Anonymous,

Will MROUND( ) work for you? Same measure of ['Mailpieces'] used in both cards in my sample dataset. 'None' in Data lable -> Display...