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.
Hi All,
Following my post.
Is there a way to filter a table according to a text column and the starting letter?
I would like to filter all texts that start with a,b,c...j. Then create another table and show only text starts with k,l,m....s, and so on.
So if I have a table with names I will get in visual1 all the names that starts with a to j, in visual2 all the names that starts with k to s, and so on.
Thanks
Currently,
I am taking the UNICODE of the first letter and using it in the filters.
The column I have created is - unicode(left(table1[name],1))
Then I filter according to the above - unicode > 65 and unicode < 74 (For example for Names that starts with A to J).
Looking for a more elegant solution.
Thanks
Hi @Anonymous
Caan you post some data in the OneDrive / Google Drive and paste the link here. Also let us know what is the final output you expect.
Cheers
CheenuSing
Hi @CheenuSing
The original issue I have is a large table with multiple records that I need to show on a monitor in the office.
So lets say I have 100 records in my table, but only 30 can be shown on the screen.
How can I show the entire table?
I thouhgt to split the table into sub-tables and to show different names.
For instance, sub-table-1 will show names from A-D, sub-table-2 will show names from E-I, sub-table-3 will show names from J-O and so on...
This is a bad solution. But the only workaround I can think of right now.
Here is an example:
List of names in the main table
Alfie |
Amelia |
Ava |
Bill |
Charlie |
David |
Eddie |
Emily |
Freddie |
George |
Gin |
Grace |
Harry |
Iris |
Isabella |
Isla |
Jack |
Jack |
Jacob |
Kai |
Lily |
Mia |
Noah |
Oliver |
Olivia |
Ophra |
Oscar |
Queen |
Robby |
Sophia |
Tina |
Victoria |
Yvonne |
Zoe |
After split
Alfie | Eddie | Jack | ||
Amelia | Emily | Jack | ||
Ava | Freddie | Jacob | ||
Bill | George | Kai | ||
Charlie | Gin | Lily | ||
David | Grace | Mia | ||
Harry | Noah | |||
Iris | Oliver | |||
Isabella | Olivia | |||
Isla | Ophra |
I started to explore the option to create a custom visual, but couldn't find enough information about what I need and want.
Ta
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |