Data for calculated columns only showing in desktop and not web

[tatianawolfe]

I added a new column to my table that counts a set of TRUE/FALSE columns by returning a numerical count. 

"Error Count = IF('Merit IPQI'[Chassis]="TRUE",1,0)+IF('Merit IPQI'[Gearbox]="TRUE",1,0)+IF('Merit IPQI'[Front Axle]="TRUE",1,0)+IF('Merit IPQI'[Pillow Block Bearing]="TRUE",1,0)..."

This column works great in desktop, but when I publish into My Workspace and access through PowerBi web, my visuals don't reflect the data within any of my columns with measures. 

How do I fix this issue? I tried creating columns in Query Editor and the column only returned 0s (no values counting the TRUE/FALSE)

[tatianawolfe]

First image is what I see on web.

Second image is what I want to be shown. 

My calculated columns consist of IF statements like this: 

Hydraulic Lift Cylinder Count = IF('Quality Issue Tracker'[Hydraulic Lift Cylin]="TRUE",1,0)

The data is pulled from SharePoint and is being published to My Workspace

[v-tejrama]

Hi @tatianawolfe ,

If your calculated columns are working in Power BI Desktop but not in the Power BI Web Service, check that you're comparing the correct data types. Using text values like "TRUE" in your DAX formula can lead to issues, especially if your data source, such as SharePoint, returns Boolean values (true or false). Instead of comparing to the string "TRUE", use the Boolean value TRUE() or simplify your expression. This should help ensure your visuals display the correct data in both Power BI Desktop and the Power BI Service.FFor example, instead of using IF('Merit IPQI'[Chassis] = "TRUE", 1, 0), you should use IF('Merit IPQI'[Chassis] = TRUE(), 1, 0) or simply IF('Merit IPQI'[Chassis], 1, 0). With this approach, your updated formula would be:

Error Count =  
    IF('Merit IPQI'[Chassis], 1, 0) +  
    IF('Merit IPQI'[Gearbox], 1, 0) +  
    IF('Merit IPQI'[Front Axle], 1, 0) +  
    IF('Merit IPQI'[Pillow Block Bearing], 1, 0)

Best Regards,
Tejaswi.
Community Support

[tatianawolfe]

Your second solution seemed to work for some of my visuals, but for some reason only two of them are not working now. The weird thing is that they are also using the same Measure.

[v-tejrama]

Hi again@tatianawolfe,

 Thank you for sharing the screenshots. Based on my review of your logic and visuals, the issue appears to be related to how Power BI processes Boolean values, particularly after publishing to the Service. I replicated your scenario with similar data and found that handling Boolean fields directly in DAX without text comparisons produced consistent results. Once I updated the logic, the visuals displayed correctly both locally and on Power BI Web.

Be sure to refresh the dataset in the Service after publishing, as calculated columns may not update fully until that step is completed. With this approach, all elements, including slicers and bar charts, functioned as intended.
I’m confident this solution will resolve the issue on your end as well.

Please find the attached PBIX and Screenshort file for your reference.

Best Regards,
Tejaswi.
Community Support

[tatianawolfe · Accepted solution]

Thank you! I realized there were some columns included in the filters for these visuals. That was keeping them from displaying in web. I removed those filters and they are now working.

Appreciate your work!

[v-tejrama]

Hi @tatianawolfe ,

Thank you for the update. I’m glad to hear that removing the filters resolved the issue and that the visuals are now working correctly in the Power BI Service.

Thank you.

[v-tejrama]

Hi @tatianawolfe ,

Glad to know the issue has been resolved. Could you share the solution that worked for you? This will help other community members who might face the same situation.

Thank you.

[v-tejrama]

Hi @tatianawolfe ,

Great to hear your issue is resolved. Could you please share the steps or solution that worked? It will be useful for others with a similar problem.

Thank you.

[FBergamaschi]

Please show the issue with images and a clear explanation of what you want to get