Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
My organisation releases data that has to include small number suppression, which is an asterisk.
This is a problem across all data analysis software I've come across, but wondered if there was a trick within Power BI to allow sorting largest to smallest (as opposed to alphabetically).
It works fine when I set all asterisk values to blank(), however we are duty bound to show the asterisks to indicate that a number has been suppressed. As soon as I allow them in, and sort by that column the numbers are organised alphabetically:
1
10
100
2
20
200
etc. Which is useless.
Is it possible to tell the table visual to treat string values as a certain number, then treat the whole column as numbers when sorting?
Any help much appreciated!
Solved! Go to Solution.
Thanks Dale,
Your advice wasn't quite what I was looking for, but it did lead me to the correct solution.
I created a new column in my table with code
My table = selectcolumns( <My other column codes>, "ColumnSort", If(OriginalColumn = "*", BLANK(), Value(ThisTable[OriginalColumn])), )
This allowed me to sort the 'Text' colunm as if it were numerical column.
Hi @ABNHS84,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
Thanks Dale,
Your advice wasn't quite what I was looking for, but it did lead me to the correct solution.
I created a new column in my table with code
My table = selectcolumns( <My other column codes>, "ColumnSort", If(OriginalColumn = "*", BLANK(), Value(ThisTable[OriginalColumn])), )
This allowed me to sort the 'Text' colunm as if it were numerical column.
Hi @ABNHS84,
Power BI has a trick indeed. Please refer to the snapshot below. You just need to add a numeric column to indicate the orders.
Best Regards,
Dale
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
54 | |
54 | |
36 | |
33 |
User | Count |
---|---|
81 | |
75 | |
49 | |
45 | |
43 |