Forum Discussion
Slicer bar
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.
1 Reply
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
