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.
I am using a column of data in a slicer , and the column contains a few garbage records that consist only of the ? character (a single ?).
I've had no luck trying to figure out what, if any, character will allow me to escape the wildcard meaning of ?, and literally search for (well, filter out) strings containing '?'.
Perhaps an escape character hasn't even been defined, but I can't find any documentation on the subject.
Solved! Go to Solution.
If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
If you want to filter out non printable characters, in the query editor, select your column, then in the Transform tab, select Format/Clean in the Text Column area, then if you want to then remove blank columns, you can apply a filter
Not sure if this is what you are looking for
If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
@Sean Fabulous, thank you! That does the trick exactly!
(OK, I'm embarrased, I didn't think to search actual Microsoft documentation...)
If you want to filter out non printable characters, in the query editor, select your column, then in the Transform tab, select Format/Clean in the Text Column area, then if you want to then remove blank columns, you can apply a filter
Not sure if this is what you are looking for
@blopez11 Actually, this is what I originally wanted, but had forgotten/given up on, as I am using SSAS Tabular, via Visual Studio... I'd completely forgotten that I could filter data there, in the processing stage.
Then I had to remember that filtering data in the grid view (not sure of the proper name) was purely cosmetic, and wouldn't impact the deployed SSAS cube... So I had to work upstream, and apply the filter in the Edit Table Properties dialog.
Problem solved!
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |