Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Advanced Filtering question sort Names A through N
12-03-2021
07:13 AM
Is it possible to bring back Provider Names that Start with the letter A through N using this filter?
Thank you!
1 REPLY 1

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2021
11:42 PM

It can't be done using this filter. But if have such a requirement, I think you will have to add another column to your table using the function UNICODE(ProviderName). This will give a numerical code for each character. Then use this numerical field in a slicer or filter to fetch values between the ranges.

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
10-18-2024 07:27 AM | |||
09-03-2024 03:27 PM | |||
06-29-2024 04:35 AM | |||
06-10-2024 03:14 AM | |||
Anonymous
| 09-17-2024 11:24 PM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
86 | |
72 | |
55 | |
39 | |
38 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
95 | |
63 | |
56 | |
48 | |
46 |