measure/column changes when opened in pbix and when deployed in app.powerbi service

[ovonel]

I need a measure/column in my cube (.bim file) to display the ‘latest refresh date’ of the cube...

To achieve this, I have a calculated column with code     =NOW()

My problem is that when I consume it from .pbix the date shows up in one language and when deployed to service app.powerbi.com it changes name….

(pbix)

(when deployed in app.powerbi)

I need to make sure that if I open the pbix and if I deploy in app.powerbi I see the same… How can I prevent this?

 (Ideally I would like to see both in English).

[v-mengzhu-msft · Accepted solution]

Hi @ovonel ，

On service, the date display format is related to the language setting of the browser itself, but in power bi desktop, the date display format will be affected by the locale setting. I understand that you want the dates to be displayed uniformly in English, and it is obvious that there is a difference in desktop.

So, you can check the "region settings" in the desktop's options and change it to English.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ibarrau]

Hi. Considering you don't need the field "to be a date" and the purpose is to show that text, you can use FORMAT to transfort it to a text with the format you wish. E.g.

FORMAT ( NOW(), "yyyy.mmmm.dd" )

More info: https://dax.guide/format/

I hope that helps

[ovonel]

what do you mean? i cannot format to any other language:

[ibarrau]

Sorry I missed a piece of answer. That will help you define de format. The language is something that depends on the browser by default. Power Bi Service will show the date, decimal points, thousands separator, etc in the browser language that might be different on what you have in your local environment.

I hope that make sense