Forum Discussion
Slicer on PowerBI
Thanks for the reply from Tutu_in_YYC , please allow me to provide another insight:
Hi Anonymous ,
Here are the steps you can follow:
If your table data contains only integer type data, you can use Parameters to create a 0-9 table with no join relationship as a slicer, and use CONTAINSROW() to determine whether the selected finger in the slicer is in the data:
Modeling – New Parameter – Numeric range
Create measure.
Flag =
IF(
CONTAINSSTRING(
MAX('NumberTable'[Number]),[Parameter Value])=TRUE(),1,0)
Place [Flag]in Filters, set is=1, apply filter.
If your data inside is text type, you can use custom visual - Text search slicer, this visual can fuzzy match the search box information.
Click on the three ellipses - Get more visuals -- Text Search Slicer
When slicer selects A, it displays the data containing A
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly