Forum Discussion
Solved
Pivot Table Column Item from Power Query Connected Data Not in Numeric Order
I've been searching around but couldn't find the answer to this. I loaded to my data model and connection only from my raw data source into a new sheet for use. In my raw data I have an order...
It looks like Order # are texts, did you try to convert them to numbers?
Thank you. I fixed in Query editor by changing the type to number and fixed it.
I overlooked this as in Excel it worked fine until I had an IFERROR that added a blank (“”) and changes that to a zero, changed the type to a number with decimals, let it update the data model, and made sure on PQ it was a number just in case.
Thank you for the help. I overlooked the simple mistake.
I overlooked this as in Excel it worked fine until I had an IFERROR that added a blank (“”) and changes that to a zero, changed the type to a number with decimals, let it update the data model, and made sure on PQ it was a number just in case.
Thank you for the help. I overlooked the simple mistake.
Jpalaci1 , glad it helped