Share via

Couldn't load the data for this visual

Juan Sandoval 20 Reputation points
2024-02-11T21:43:22.69+00:00

Hello I'm trying to create a Gantt chart using a matrix in Power Bi. I followed instructions using a YouTube video I found, but on the step to create the measure for the 1's I'm getting an error. It states it "Couldn't load the data for this visual" and beneath that it states MdxScript(Model) (15,5) Calculation error in measure 'Project Data'[Column Values]: DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using VALUE or FORMAT function to convert one of the values.

The issue is that the columns with relationships are all the same format - Short Date, so not sure what it needs me to change formatting on.

Community Center | Not monitored
0 comments No comments

Answer accepted by question author

Erland Sommarskog 134.6K Reputation points MVP Volunteer Moderator
2024-02-11T21:51:21.12+00:00

PowerBI is not supported on Microsoft Q&A. Instead consult the PowerBI forums at https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.