Forum Discussion
Filter Start With
- 1 year ago
This solution allows you to filter the page using the first two characters of the number. You can also just add this value as the top layer of a slicer hierarchy if you want to eliminate the need for users to 'search' using their keyboard for the first two numbers, as the other user suggested.
I created a table with some of these numbers.
Then in Power Query I used "Extract" to get the first two characters in a new column:
Then I created a slicer using this new column in the report. Here you can see me using it to filter on 14% and 19%.
Here it is using a multi-level hierarchy for the slicer:
Attached is the .pbix file solution.
///Mediocre Power BI Advice, but it's free///
Hi!
Could you not solve this by enabling the search function in the slicer? To enable it hover over the slicer and click the three dots at the top left corner. Then enable the search!
- tksnota011 year agoFrequent Visitor
will this feature work for columns containing numbers? I tried this approach but i can't make it work...