Please Help me to change the data format in Direct Query Data.

[krrish116]

Hello,

I have been trying "Direct Query" to our sql server tables all on 1 database, and it seems to work fine. But now I bumped on limitations of Direct Query, when I tried to make transformations with a column which it contains sales data .

I have shown those sales in a chart where the total sales data per month is showing in 3 , 2 or 7 Millions.

But our client dont want to see the data in Millions.

Example in bar chart , The sales in january are 3.2 Millions, they want to see only 3.2 not the 3.2M in chart. 

Sales in Feb are 2.4 Millions, they want to see only 2.4 not the 2.4M in chart.

I tried in N number of ways to solve it, but i cant make it due to data is from direct query.

Please help me on this.

@Help.... @amitchandak   @parry2k 

[amitchandak · Accepted solution]

@krrish116 , check formatting string can help - in model properties

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[Greg_Deckler · Accepted solution]

@krrish116 - Should be able to use the technique in Chelsie Eiden's Duration. https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

Or perhaps create a measure using the FORMAT function.

[amitchandak · Accepted solution]

@krrish116 , check formatting string can help - in model properties

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[krrish116]

Hi @amitchandak ,

currently im using #,0,

but im getting 1668 instead of 1.6

Please let me know what is the exact string to get it.

Thanks,

Krishhh...

@help....

[krrish116]

Hi @amitchandak ,

Im using #,0,

but im getting the value like 1.6M is showing like 1632.

So, Please guide me for getting only 1.6.

Thanks,

Krish...