Forum Discussion
Format DirectQuery Data as Currency
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
Microsoft EmployeeHi,
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.
Mi2n - Can you ellaborate? While in DirectQuery mode there is no "Data" section which is where you would normally apply formatting changes using the modeling tab in the ribbon.
Hello jonculp85
you're right, since you use Direct Query with Sql you cannot change the datatype on Power Bi desktop. Here is what you should have :
But, if you click "Modifiy Query", in Power Query you should be able to change the datatype. I've managed to do it with Direct Query and Sql Server.
Modifying the data type is not supported in DirectQuery mode. Unless I am mistaken, the data type is not the issue in my case; what I need to change is the number "format". The client wants to show the currency sign ($) in the visualization for sales, and I agree with them that it makes sense to show it in order to differentiate from counts or "number" of sales. You can change data type at the visualization layer, but you can not format as currency. It would be really nice if PowerBI would allow you to change the number format at the visualization layer to add a currency sign. However, it really should be done at the data layer so that the formatting can propagate to all objects that use the field.
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