In PowerBi service data is not showing correctly when I am using show table option.

[Anonymous]

I am using ""#,0;(""#,0);""#,0 format for my measure and in the service it is showing format instead of data when I am using show table option for the graph .

This is happening for measures which are in decimals. This is working fine in PBI desktop but in service it is showing incorrectly.

[Anonymous]

on further if I create report level measure with format as ""#,0;(""#,0);""#,0 then again its showing incorrectly in the service.

[Anonymous]

Hi Collinq,
The measure Totalx= netevenue-cost and the format of the final measure is ""#,0;(""#,0);""#,0.
Netrevenue format string is ""#,0;(""#,0);""#,0
cost format string is ""#,0;(""#,0);""#,0
The issue is happening only in service when I am using show table option on the graph instead of value its giving me the format in the table.
Its showing correctly in the desktop,

[collinq]

Hey @Anonymous ,

I misunderstood at first and was thinking that you did the formatting in the formula, but I am realizing that you did it elsewhere.  I am curious, is the issue the same with different browsers?

[collinq]

HI @Anonymous ,

There could be a few different issues for this, can you please post your exact measure that has the formatting?  I am assuming that you opened it in Desktop and it displays fine there?

[Anonymous]

Hi Collinq,
The behaviour is same in other browsers too. On further analysis I found that the issue is happening when I am using line and clustered column chart. The measure which is being used in line value shows the format of the measure whereas the measure which are in column values shows the data correctly. Its a weird behaviour of the PBI. All the measures are coming directly from AAS. If I create a report level measure with powerbi datatype as decimal then its working fine in the service.

[collinq]

Hey @Anonymous ,

I think that you have narrowed down the issue.  I also think that you should turn in a ticket/issue to Microsoft (I think that these are their visuals) as they may be able to resolve something like this and may not know about this specific issue.