List all entered values in the new text slicer

[MarDen94]

Hi, 

I am working with the new Text Slicer (introduced in 2024-11) and especially with the 'Accept Multuple Values' option. After experimenting al little bit I would like to list all entered values in the text slicer in a seperate measure, so that I can use it in a dynamic column title. 

I've gotten as far as trying to use CONCATANATEX to list all values of the searchable text in a single line. But I would only like to retrieve the values that the user is searching on. Is this possible?

[Anonymous]

Hi, @MarDen94 
Thanks for reaching out to the Microsoft fabric community forum.

Regarding the issue you raised, my solution is as follows:

1.First, regarding your initial requirement to "list all values entered in the text slicer," you can try the following measure, which will output all your desired results:

list all entered values =
VAR SlicerValues =
    VALUES ( 'userTable'[userColumn] )
RETURN
    CONCATENATEX ( SlicerValues, 'userTable'[userColumn], ", " )

The result of this step is as follows:

2.Secondly, regarding your idea of using dynamic column headers, strictly speaking, column names cannot be captured using DAX. However, if you use a field as a column in a matrix or use a parameter field, I suggest using a measure as a page filter. You only need to check if the value is within the selected range.

For more details, please refer to the documentation:

Solved: Visualization data changes when using count filter... - Microsoft Fabric Community

Use parameters to visualize variables - Power BI | Microsoft Learn

3.Lastly, for "retrieving only the values the user is searching for," you need a calculated table as an admin table. Then, use the following measure to filter the visual object and use the column from the admin table as a slicer:

adminTable = 'userTable'

MEASURE =
IF (
    MAX ( 'adminTable'[adminolumn] ) IN VALUES ( 'userTable'[userColumn] ),
    1,
    0
)

The result is as follows:

You may need to note that the fields used for visualisation should all come from the admin table, and you should add a measure filter for each visual object.

I hope my explanation is clear and helpful to you.Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MarDen94]

Hi @Anonymous, 

Thank you for the extensive answer, I haven't gotten around to test it yet. But I most ceraintly will. And will make sure to accept this as the solution when it solves my querstion.

[Anonymous]

Hi,@MarDen94 
Thank you for your prompt response.

I hope my answer has helped resolve your issue.If you have any further questions, please feel free to reach out to us.

Thank you in advance

Best Regards,

Leroy Lu