Problem when developing a report in Service

[hazv]

Hi, I have one dashboard connect to many databases and I also have a measure that the result is 19920,15. 
I published this report in my workspace and then opened in Tabular Editor, after that, I changed all tables from directquery to import. At this point, there is not any problem. The problem is when I open the report in service to create a new visual, the same measure now is 1992015,00. Do you guys know what happend and how can I change to the righte value (19920,15)?


Thank you

[v-jianboli-msft]

Hi @hazv ,

Have you tried to open the report in Desktop? If it displays in the right format? If it is not dispalying in the correct way, please try to change the format of the measure or change the Data type using Local in Power Query.

For example:

Best Regards,

Jianbo Li

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

[hazv]

The problem is that I cannot open pbix in Desktop mode. I edited the file in tabular editor. So, I don't know how to change the data type in tabular editor