Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have information in a table on Power BI where it will show the value figure against a name. I was wondering whether it was possible where if I select a particular name, it will hide the other names but still show the value, meaning you can see where that person ranks against everyone else, but without seeing the other names as it is confidential if that makes sense?
Hi @MIRZAMU ,
Do you want to only get the current user info and rank value compare to the others users? If yes, you can refer the solution in the following thread. Hope it can help you resolve the problem.
Show Current Logged in User data only
Measure1
WhoIsWatching = USERPRINCIPALNAME()
(that is email style usernames, or you can use USERNAME() for windows style users)Measure 2
FilterByViewer = IF(selectedvalue(table[email])=[WhoIsWatching],1,0)
Drag Measure 2 as a filter for visual, select advanced filtering and set it to
"Show items when value IS 1"
Show the information but not the details: Power BI Data Masking
Showing Ranking in a Visual in Power BI using RANKX DAX function
Best Regards
Hi,
Thanks for your reply.
I have tried using these measures but they do not seem applicable for my report.
This is a screenshot of my report.
See the table on the left. if I select a name from the left hand column (which has been coloured out), I want the names to be anonymised / blank, but the values still to show. Same with the Column Graph on the right. I have labels underneath each bar but when selected, I want the names to be blank except the selected name of course
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |