Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
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?
Hi @vnicholl ,
You need click the column first. Then column tools will outcome.
Best Regards
Community Support Team _ chenwu zhu
I click on the column, no column tools. I click on the header and no column tools either.
HI @vnicholl
Can you use measure? if yes, try this measure:
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/
I am new to Power BI Desktop. Where would I put in a measure?
Hi @vnicholl
Check this link:
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/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |