Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
            | User | Count | 
|---|---|
| 5 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | 
| User | Count | 
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 5 | |
| 4 |