Applying changes to queries

[vnicholl]

I have a production table that I'm creating a report in for power bi desktop. I have a field that is numeric, like 2332, and if it has decimals it shows the places 323.22. 

My question is, I want to show a report with dollar signs. It looks like the only way I can do that is to modify the underlying table. As this is a production table, do I need to create a copy of the table, or can I apply the changes without it truly affecting the table itself (just what Power BI sees of it)?

Thanks, 

Vic

[v-chenwuz-msft]

Hi @vnicholl ,

Actually, you don't need to change the underlying data.Power BI Desktop provide many number type include currency symbol.

Under Column tools, change the number field type as Decimal number if you want have decimals. Chose currency symbol via the down arrow side by $ icon.Enter 2 if you want two decimal places.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vnicholl]

I don't have column tools. I only have up to data/drill. Nothing after that in the top part. So where do I find that on power bi desktop? 

[v-chenwuz-msft]

Hi @vnicholl ,

You need click the column first. Then column tools will outcome.

Best Regards

Community Support Team _ chenwu zhu

[vnicholl]

I click on the column, no column tools. I click on the header and no column tools either. 

[VahidDM]

HI @vnicholl 

Can you use measure? if yes, try this measure:

Measure = format(MAX('Table'[Column1]),"$##.00")

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[vnicholl]

I am new to Power BI Desktop. Where would I put in a measure? 

[VahidDM]

Hi @vnicholl 

Check this link:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures#create-a-...

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/