Using Text Filter to show filtered data

[rezaaditia]

Hi All -

I have huge of dataset of purchases, and want to share to users but only based on their Request no.

I am thinking to use text filter in empty page then when they fill the request no in text filter, it will show the results based on the request number input.

is it possible?

Thanks

[Anonymous]

Hi @rezaaditia,

I'd like to suggest you configure the RLS filter based username, you can setting a user table to mapping username with request-id.

RLS with UserName() 
Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@rezaaditia , you have create all measure like

new measure =  if(isfiltered(Text[text]),[Measure] ,blank())

all measures need to consider if the text is filtered 

also, refer for text filter

https://exceleratorbi.com.au/text-filtering-power-bi/

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview