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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Published dataset format is different to Desktop format

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

Ashley9686_0-1668508478152.png 

Desktop conditional formatting

Ashley9686_2-1668508877691.png

 

Service Dataset

Ashley9686_1-1668508621443.png

Service Conditional Formatting

Ashley9686_3-1668509029789.png

 

Any advice would be greatly appreciated. Thanks, Ash

 

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

 

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

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.