Forum Discussion
Solved
Using Text Filter to show filtered data
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 ...
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
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