Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

Totally unable to pivot this using PowerQuery and I am not sure why


Okay so my data looks like this:




And it goes down a long way.  What I want to do is to pivot this table based on the FinancialYearStart column. so that I get something that looks like


ProjectCode   2011  2012   2013  .......

Code              sum   sum    sum .......


Now this should be a classic but it just fails giving me this...



Looking at each of these the error is






Resolver I
Resolver I




I have absolutely no idea why this is.  I've tried using a replace to ensure any nulls are not nulls but this still happens.  I really need this but just cannot get it to work.


Anyone got any ideas?

Impactful Individual
Impactful Individual

Is PBI automatically adding a convert values row to your query? its caught me out with that before. 

Turned out that an earlier step in the query that generated the source was adding an issue into the table.  Using a try otherwise on that eliminated the dodgy row/rows and the pivot worked 🙂


Helpful resources

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!