DYNAMIC ID?

[fbernardazzi]

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

[KNP]

If I understand correctly, you could create a rank measure of some kind.

What is the purpose of the ID column at that point?

[fbernardazzi]

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

[KNP]

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.

[KNP]

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.

[fbernardazzi]

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.