Change Currency Symbol - DirectQuery

[LaDTigaTiga]

Hi there,

I have created a visualisation that shows the revenue amount for a specific company. I want to change the currency symbol from R to $. I know that one can change the symbol in the Modelling tab, but that option is not available to me, maybe because I am connecting via DirectQuery to a database on a virtual machine. Is there a way of changing the currency symbol without me having to change my connection to Import?

Thank you 🙂

[LaDTigaTiga · Accepted solution]

I solved it. I had to click on the column under fields. It then gave me the modelling tab.