Forum Discussion
All data is null
- 4 years ago
Sorted Rows in Power Query will not affect sorting of data in Visuals. The ONLY reason to have Sorted Rows in Power Query is if the sorting is needed for something like a Row Number column or Running Total, where the order is important. In your charts and graphs, you always have the ability to sort by some column in the visual.
Try removing the Sort operation to make your query go faster.
Now to your issue, try filtering the data to remove NULLs. I bet this is Excel data, which is infamous for having extra rows and columns that nobody wants.
Try stepping through the Applied Steps, seeing what each one returns in the data grid. Find out where those NULLS show up.
- Anonymous4 years agoNot applicable
Hi ToddChitt,
Thank you. It looks like the 'Sorted Rows' applied step is returning the null values. Please see below.
If I remove this step, I might mess up following steps which are crucial for my visuals. What is the best way to go about this?
Data is showing with step previous to 'Sorted Rows'