Forum Discussion

nunnc01's avatar
nunnc01
Icon for Helper II rankHelper II
7 years ago
Solved

Deleting row where column contains text

Hi,   I have a column of data coming in to Power BI from our system that should only contain numbers. However somehow a piece of text has been stored which is now preventing me from having the colu...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi nunnc01 

    Assume you have table

    Format->Trim (Returns the result of removing all leading and trailing whitespace from text value text.

    Change type to whole number

    Replace error with null

    Finally, remove null.

     

    Best Regards
    Maggie
     
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi nunnc01 

Assume you have table

Format->Trim (Returns the result of removing all leading and trailing whitespace from text value text.

Change type to whole number

Replace error with null

Finally, remove null.

 

Best Regards
Maggie
 
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Whibley92's avatar
Whibley92
Icon for Helper II rankHelper II
2 years ago

I am trying to perform this on a column with only 2 sets of criteria (I'm very new to Power BI). I would like to permanently deleted the rows with one particular category, rather than just filtering out as there is a lot of data. How do I perform this?