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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
cj1905
Advocate II
Advocate II

Direct Query Regional Settings

Using Direct Query to an MDX model and custom visuals e.g Bullet Charts (both Microsoft and OKViz variations tested), the currency fields formatted for British Pounds (£) all become dollars ($). The standard power BI visuals all show £s for the same measures as expected.

I have tested the same situation when using import mode with none of these issues present.

I presume this is related to the "Regional Setting" option in Power BI Desktop however this is not available when using Direct Query. 

Any ideas? 

It makes the custom visuals a bit useless for British businesses with this scenario.

(I am using the latest version of Power BI Desktop optimised for Report Server [March 2018])

1 REPLY 1
cj1905
Advocate II
Advocate II

Using Direct Query to an MDX model and custom visuals e.g Bullet Charts (both Microsoft and OKViz variations tested), the currency fields formatted for British Pounds (£) all become dollars ($). The standard power BI visuals all show £s for the same measures as expected.

I have tested the same situation when using import mode with none of these issues present.

I presume this is related to the "Regional Setting" option in Power BI Desktop however this is not available when using Direct Query. 

Any ideas? 

It makes the custom visuals a bit useless for British businesses with this scenario.

(I am using the latest version of Power BI Desktop optimised for Report Server [March 2018])

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.