Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have this table with thousands of account numbers, which have different start letters.
for example, account# can be in the form of:
ABC######, ASD######, ADF######, AGH#######, BFD######, EIO#######, ERT######, etc, and there are thousands of account# with each starting letters.
The table visual I want contains account#, and some other columns. If I only want the table to show account# in the form of ABC#####, ASD#####, ADF######, AGH######, how can I do this?
I can set "Filter on this visual", however it will only let me add at most 2 filters, seen below, however I need all four.
I know I can filter in Query editer, however I cannot do this because my other visuals on the dashboard need all the account# not only the filtered ones.
Solved! Go to Solution.
You could create a new column with only the first 1 letters. (a category)
Then you could do basic filtering on that category.
Do you understand my explenation?
Robbe
Hi,
You can create a calculated column formula
Cat = LEFT(Data[Account],3)
Now create a slicer and drag this column in there. Select whatever you want.
Hi,
You can create a calculated column formula
Cat = LEFT(Data[Account],3)
Now create a slicer and drag this column in there. Select whatever you want.
You could create a new column with only the first 1 letters. (a category)
Then you could do basic filtering on that category.
Do you understand my explenation?
Robbe
Hi, Thank you for your response that works,
what if in the future I need the same thing but with cube connection(which cannot add new columns or do query editor), is there any way to achieve the same result with measure? Lets assume the account# I want does not necessarily all start with 'A', hence filtering on all three starting letters will be needed.
You are welcome. Share some data and show the expected result.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |