Forum Discussion
Solved
Format DirectQuery Data as Currency
For DirectQuery mode in PowerBI, you lose the ability to format the data. My data source is an azure sql database. Is it possible to somehow tell PowerBI that you want a specific field to be format...
Hi,
I am not sure what could be wrong here. But, it is possible to change the format even in DirectQuery mode by selecting the Modelling ribbon menu -> Format -> Currency.
So, the solution was decribed by Mi2n.
You select the measure you want to change format, in the modelling (or modeler I don't know I'm using the french Power BI desktop version) :
you select the format change and choose currency with the region you want.
Sébastien
So, the solution was decribed by Mi2n.
You select the measure you want to change format, in the modelling (or modeler I don't know I'm using the french Power BI desktop version) :
you select the format change and choose currency with the region you want.
Sébastien
Thank you so much! I was struggling to resolve this issue all day and your fix worked instantly!