Measure results not showing in Card(new) visual in Service but is on the Desktop

[PBIX_COACH]

Hi Team,

I have a bizarre issue that I can't seem to figure out. I created a report in Power BI desktop with a normal measure, and everything seems to work fine on the desktop. However, once I publish the report to the service it works however when the data is refreshed those values turn blank in the card visual. I have tried to delete and re-publish and it works but then once it refreshes it goes back to showing blank however back on the desktop it shows the values. I have other measures and visuals on the report but only these two measures are showing up blank everything else works and lines up with what is in the desktop.

Any help is appreciated.

Desktop View

Service View

[Anonymous]

Hi @PBIX_COACH ,

Did you enable the incremental refresh?

Best Regards,

Wearsky

[PBIX_COACH]

@Anonymous I have not. I have only set up a schedule refresh in service.

[lbendlin]

There's no magic to this - follow the measure formula, pay special attention to datetime columns (the service runs on UTC, which may not be your timezone).

[PBIX_COACH]

Thanks for the suggestion @lbendlin. I did check, and the measures are fine. It's just strange that the results are correct on the desktop but now show up in service. and the other measures are all working on the service but these two aren't.

[lbendlin]

I did check, and the measures are fine

they are clearly not fine when the results differ.  Look again.

[PBIX_COACH]

I'm sorry perhaps I'm missing something here but wouldn't the measures be broken in both the desktop and service if they were incorrect? Please pardon my ignorance but I have never come across this issue where my measure results disappear once I publish my report to the service.

[lbendlin]

I have seen that more often than I would like to admit.  Most of the time (pun intended) it was caused by my (wrong) assumptions about timestamps. Other times (pun intended again) it was a misunderstanding on my side on how incremental refresh works, etc.  

[PBIX_COACH]

 I'm not using incremental refresh however I did notice that the problem occurs when the refresh is manually done in service or the schedule refresh runs in service and then the values for the measure disappear

[PBIX_COACH · Accepted solution]

I found the issue. It was the data type in Power Query I had a true/false criteria which should have been classed as a text argggg! thanks for your help.