Slicer bar

[SBePicas]

Apologize for duplicate as I posted question but was not explained correctly.

I have five visual cards in the canvas (each with one column)

Column 1    Column 2   Column 3   Column N

A                             A             A                            A

B                            B             B                            B

C                            C             C                            C

                              D             D                            D

                                                 E                             H

                                                 F                             L

                                                                                M           

How to create a search that will list values in all visuals.

Example if search “C”, All columns will show that but if search for “F” then only column 3 will show that.

Tried to use the slider but it can only use one column as the basis for searching.

[amitchandak]

@SBePicas , One way is to create a concatenated column and use text filter

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

Another is unpivot the data and use Matrix Visual and Slicer on Values

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

3rd is have slicer with Independent table having all the values from column 1-n and create measure like this

countrows(FIlter(Table, Table[Column1] in Values(IndTable[Value]) || Table[Column2] in Values(IndTable[Value]) || Table[Column3] in Values(IndTable[Value]) || Table[Column4] in Values(IndTable[Value]) ) )

Add other columns