Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am trying to create a report and publish across all production operator their daily output(on mobile view)
But i want the report to function in this way, a seceret password is shared to them, so when they type the password on search they get to see the daily output quantity about them alone.
is it possible to do such thing in BI report?
Data table
Password
1)ideally the report should display blank data
2. each operator was given a secret password , and they will enter in search filter their own password and can able to see their data alone.
in the below case operator = vin, password = 2
operator=mar, passwoed = 5
the challenges for me are, i donot know how to make the initial data table emply, and how to make a search column or search filter where you can only enter data and wont see any hint text/number or all available password from data table.
it would be very helpful if someone can help me with this, or you can also recommend me someother way so i can reach the same conclusion.
the plan is to give some kind of seceret number to each operator which only they know, they go to shared report of power bi in their mobile and type their own password in the search and get to see only their data. and the initial data table should be empty in the start and search filter should not show any hint password of all possible data password available from the password table.
any help is appreciated.
Solved! Go to Solution.
Hi @Anonymous
Brilliant idea! And I've just found a way to implement this!
Seems to be working! Let me know if you see any flaws.
Passwords for testing: power and dserw
1) Install Text Filter slicer:
2) Two measures used: