Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Assuming that with BLANK, you mean that the cells are empty on the screen: you may have some invisible characters in those fields, such as a space. You can find that out by using Transform-Extract-Length in Power Query, which will replace the content of the cells in your column with the length of whatever is in those cells. If it is anything other than 0, the cells aren't actually empty, they just look that way.
If the cells are not actually empty, you need to figure out what's in them.
If what you see on the screen is the text "BLANK", use the same method, the length should come out as 5. Anything else, same problem, you have some invisible characters in that text.
1. Right click on the column
2. Choose "Replace Values"
3. Leave "Value To Find" empty (do not type in the box)
4. Enter in the desired text in the "Replace With" cell
5. Click ok
This is for truly empty cells to replace with text.
@all you can use below formula to replace a blank with a text.
Newcolumn= if(LEN('Table'[columnvlue])=0 ,"Not available",'Table'[columnvlue])
if it's help don't forget to give a thanks 🙂
Assuming that with BLANK, you mean that the cells are empty on the screen: you may have some invisible characters in those fields, such as a space. You can find that out by using Transform-Extract-Length in Power Query, which will replace the content of the cells in your column with the length of whatever is in those cells. If it is anything other than 0, the cells aren't actually empty, they just look that way.
If the cells are not actually empty, you need to figure out what's in them.
If what you see on the screen is the text "BLANK", use the same method, the length should come out as 5. Anything else, same problem, you have some invisible characters in that text.
Hi,
this was a little embarrassing, but thank you very much for your help. It worked excellent.
Best regards
Marius
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |