Matrix showing the wrong measure values and error when row is expanded/collapsed, but not in Desktop

[Anonymous]

So I have a report on Desktop which all shows the right value and functions well, but there's one matrix on the published version which poses this problem. Because my data is sensitive, I'm just going to post a portion of it.

This matrix have two measure columns that showed the wrong row aggregation value and didn't sort by itself when it's supposed to. Here are the columns when on Desktop (right values and sorted by rank):

When on Service (wrong values and not sorted):

Also when I tried to expand or collapse from the row headers, the visual will have the "Can't display the visual" error, all the meanwhile it doesn't have this error when I'm drilling down/up from the visual header. Here is the error message:

One thing I noticed is that, when I first open the published version after publishing it, for a slight time the matrix shows the right values and sorted, but there's still the loading icon on the left-top of the matrix which means it is not fully loaded.

After it loads, it shows the wrong value as I described earlier.

This report have been published for around 5 months and I never change the measure values.

I have never encountered this kind of issue and i hope i could get a solution with this.

Thank you.

UPDATE: So while I was trying to figure out, I realized that the error for the matrix only happens when I add conditional formatting for the two measures which shows wrong values on service. After I removed both conditional formattings, the measure columns show the intended value and don't give errors. This doesn't make sense since Formatting shouldn't even be messing with the value calculation, so my guess is that something has to do with the recent update changes.  I need conditional formatting for the 2 measures, therefore I need a solution.

[v-easonf-msft]

Hi , @Anonymous 

Did the report  show the right value and functions before ?Has the problem only started recently?

On the forum side, it's hard for us to provide any more support about this issue. It is suggest you open a support ticket to get dedicated support from the Microsoft personally.

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

Yes it happened a week ago when I republish the report, I still don't know what causes it, probably either from my own dataset updates or power BI updates.

Found a workaround solution:

The thing I noticed is that, when I use background Conditional Formatting for the rank measure column without stating a custom minimum value and maximum value on the rules (in which keeping it default min and max), this causes not only its column values to be incorrect but the Cont. value as well. The workaround is to give a custom value to the min and max rules value, it fixes it.

Thank for the suggestion, I will look after this problem later when I have the time.