Filled blank rows

[souvikghosh98]

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

[v-aatheeque · Accepted solution]

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!

[v-aatheeque]

Hi @souvikghosh98 ,

We wanted to follow up regarding your recent inquiry to see if your issue has been resolved ?

[v-aatheeque]

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!

[v-aatheeque]

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!

[Omid_Motamedise]

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?

[ToddChitt]

Can you show us some sample data of what you have, and what you are trying to get to?