Forum Discussion
Create dynamic table based on text filter values
Hi guys, i need felp for this:
As you can see I have a TEXT FILTER and TABLE displayed below:
What I need here is to hide all the values in the table as the first sight, user can only see the values by typing what they need in the search box).
Hi phuocnguyen ,
You can try below steps:-
1. Create a seperate table with below code:-
Table = DISTINCT(Sheet1[OrigSalesId])2. Use newly created table column in the search text visual.
3. Now Create a measure with below code and use it as filter on your table visual:-
_filter = IF ( MAX ( Sheet1[OrigSalesId] ) = SELECTEDVALUE ( 'Table'[OrigSalesId] ), 1, 0 )Below is your file for your reference:-
Thanks,
Samarth
8 Replies
Hi phuocnguyen ,
You can try below steps:-
1. Create a seperate table with below code:-
Table = DISTINCT(Sheet1[OrigSalesId])2. Use newly created table column in the search text visual.
3. Now Create a measure with below code and use it as filter on your table visual:-
_filter = IF ( MAX ( Sheet1[OrigSalesId] ) = SELECTEDVALUE ( 'Table'[OrigSalesId] ), 1, 0 )Below is your file for your reference:-
Thanks,
Samarth
Hi Samarth_18 ,
Thank you for your instruction, but the file has been deleted, could you check it again?
phuocnguyen ,Please check your Private message. I have sent you updated url.
Thank you, this work well for me.
Hi phuocnguyen
did you add the OrigsalesId column to the field of Text filter visual.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
