Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a column "Process Step" with qualitative data, but there are many "null" values that prevent me from pivoting the column. I get errors I can't pivot cause of NA values or blank
I do NOT want to keep rows with nulls. I want to remove these rows entirely.
How can I edit the query and removet hese rows where null exists in a specific column?
Solved! Go to Solution.
@Anonymous
I think you can add a step in the PQ which is filtering that column
Proud to be a Super User!
@Anonymous
I think you can add a step in the PQ which is filtering that column
Proud to be a Super User!
@ryan_mayu wrote:@ryan_mayu
I think you can add a step in the PQ which is filtering that column
You can add a step to filter the column, but doing so doesn't appear to let me pivot still. I get "DataFormat.Error: Invalid cell value '#N/A'." when I try to pivot.
@Anonymous
could you please provide the sample data and the expected output?
Proud to be a Super User!
Filtering it did work actually. I was doing something wrong. Thanks!
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |