Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |