Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Published dataset format is different to Desktop format



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


Community Support
Community Support

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

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors