Forum Discussion
DYNAMIC ID?
Hello everyone.
I have a base that has the following LETTER and ID columns.
LETTER ID
A 1
B 2
C 3
A 4
E 5
A-E 6
It is possible to create a "dynamic table" that when I filter with visual "Text filter" it looks like this:
filtered with the letter A
LETTER ID
A 1
A 2
A-E 3
5 Replies
If you're able to use certified custom visuals, you could just add the Text Search Slicer to your report.
It does a contains search by default.
It also allows wildcard use.
Thanks for the reply. Yes, I can use certified custom visuals. It works, but that's not all I'd like to do.
Filtering by the letter A
I need that instead of appearing the IDs that have already been defined, appears 1, 2, 3. Can you understand?
Like this
in this example I made a calculated column to demonstrate, but it would be impossible to do for a real database.
If I understand correctly, you could create a rank measure of some kind.
What is the purpose of the ID column at that point?
It would be to differentiate the records. When using Text Filter, it would filter the slicer with the found records.
Currently
I wish it stayed that way
I tried to make a measure, but it didn't work
Now I understand what you mean.
I don't believe that is possible, measures are the only thing that will calculate based on slicer selections and you can't use them in a slicer.
