Forum Discussion
Custom RAG Column in MSP but Null Value in Power Query Editor
Hi All
I haven't been able to find an answer regarding this issue anywhere but apologies if this has been resolved elsewhere and I would appreciate if you can point me in the right direction.
I have a custom RAG column in an MS Project Template which returns Null Value in Power Query Editor, when trying to create a dashboard visual based on this and other columns. Is it relating to the formatting of the column as it's set to appear as a circle symbol with respective colour of the RAG from the dropdown list?
2 Replies
Hi MO14STA ,
You can always re-create the logic behind that RAG column in Power Query with a conditional column since it looks like what you are looking for is not possible according to this:
Solved: Custom Column from MS Project in Power BI Desktop - Microsoft Fabric CommunityIf I was to recreate the logic in Power Query, I would have to manually update the rows with the RAG Status? Not an ideal workaround
I have other custom columns in my Project Template that are pulling through into PowerBI, albeit some with the true values and other with Null Values also
