Published dataset format is different to Desktop format

[Ashley9686]

Hi,

I have created a dashboard from a SharePoint list and it all the measures and conditional formatting is working fine in Desktop. However, once I have published the dashboard it's not the same. I have compared the datasets and noticed that the formatting is different which is what I think is causing the problem. In Desktop the value is pulling through a TRUE, but in Service it is pulling the value as -1, and due to this, the measure isn't picking up that the milestone has been completed.

below are the examples of what I see in Desktop compared to Service.

🤔

Desktop dataset

 

Desktop conditional formatting

Service Dataset

Service Conditional Formatting

Any advice would be greatly appreciated. Thanks, Ash

[v-xiaoyan-msft]

Hi @Ashley9686 ,

I'm not quite sure I understand your needs, would you mind providing more information so we can better help you?
I tried to reproduce your problem based on the information you provided but it didn't work, am I missing something?

Best regards.
Community Support Team_ Caitlyn