Forum Discussion
How to implement slicer for an Alphanumeric field
Might be difficult to achieve in DirectQuery mode so you might have to use a Composite Model. Generally you handles these sorts of things with disconnected tables that you use as your slicers. You grab the MAX/MIN value from each of these tables and write your measures such that they do the filtering between these values. You might be able to do it with two slicers that do not filter one another. Grab the MIN and the MAX of the table, which should represent your two "ends" and then write your measures accordingly.
But, sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Anonymous, any thoughts on the work-around I presented?
Anonymous yes I'm aware of this functionality but this will only work for numeric columns. Mine is an alphanumeric one with the pattern A1, A2, A3, A4, A5.... A9, A0, B1, B2, B3........, B9, B0, C1....... So the only 2 options i see in the slicer are dropdown and list. I understand there's no direct way we can do this. I am looking for a workaround.
Anonymous, any thoughts on the work-around I presented?