Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
jaryszek
Memorable Member
Memorable Member

Each time when I am creating calculated column i need to set up currency

Hi Guys,

every time I created calculated DAX column I have my PLN values there if this is a currency field. 
So every time i need to go here:

jaryszek_0-1743760076472.png

 

and set up dolar as my default value,
How to set up this only once?

Best,
Jacek

 

1 ACCEPTED SOLUTION
8 REPLIES 8
jaryszek
Memorable Member
Memorable Member

 

thank you @ZhangKun @lbendlin .

Imagine that I am creating report for usa, poland and japan. 

How can I make this calculate column specific for local currency? I do not want to force it for only chosen one. 

Best,
Jacek

Define "local" . What should happen when a Japanese colleague visits the Warsaw office and looks at the report?

He will open report and see measure with japanese currency, not polish one. 

ZhangKun
Super User
Super User

It is not possible.

Please note that setting the currency format does not automatically convert every value in the column to currency type.

thanks

lbendlin
Super User
Super User

unfortunately there's no way to do that yet. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

thanks

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.