Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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