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 🙂