Forum Discussion
Filled blank rows
In a Category column, 4000 rows are there with "M" and "F" values and 1000 rows are blank in that category column. paralally Name column which is filled with values with no blank rows. This Category column is more important. Then how do we handle those 1000 blank rows out of 4000 rows? what do we need to do? Using of power query
Hi souvikghosh98 ,
Thanks for reaching out to the Microsoft Fabric Community forum.
Omid_Motamedise ToddChitt Thanks for your prompt response.
In the dataset, we have a Category column that contains some blank rows. Here’s how we can handle these blanks using Power Query:- You can replace the blank values with a default value (e.g. "Unknown").
-
Ifyou are still unable to resolve the issue. Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
-
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
If our response or a community member’s response addressed your query, please mark it as 'Accept Answer' and click 'Yes' if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
6 Replies
Can you show us some sample data of what you have, and what you are trying to get to?
What do you want to do?
there are several senario to handle missing value like removing them, replacing them with the nearest record and so on, what do you want to do exactly?Hi souvikghosh98 ,
Thanks for reaching out to the Microsoft Fabric Community forum.
Omid_Motamedise ToddChitt Thanks for your prompt response.
In the dataset, we have a Category column that contains some blank rows. Here’s how we can handle these blanks using Power Query:- You can replace the blank values with a default value (e.g. "Unknown").
-
Ifyou are still unable to resolve the issue. Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
-
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
If our response or a community member’s response addressed your query, please mark it as 'Accept Answer' and click 'Yes' if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi souvikghosh98 ,
We wanted to follow up regarding your recent inquiry to see if your issue has been resolved ?Hi souvikghosh98 ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
