Forum Discussion
Henryk
4 years agoFrequent Visitor
Text search slicer in multiple column
Hi, I need ONE Text search slicer for search text in two column - find text in column1 OR column2. when I work with numbers from two columns I create measure with OR function like: OR filtrace Od...
- 4 years ago
I resolve it with COMBINEVALUES :
StateCountry = COMBINEVALUES ( "|", Customer[State], Customer[CountryRegion] )
from:
Henryk
4 years agoFrequent Visitor
Hi @hnguy7,
Thank You for reply. What is this Sample formula - measure or column? Because in column it wrote me "cannot work with String parametr" :
https://drive.google.com/file/d/1xVtsyg_VOPnqyGk_o132MucpKMHEftlp/view?usp=drivesdk
and measure I cannot add to Text search slicer.