Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
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 Community
If 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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!