Forum Discussion

MIRZAMU's avatar
MIRZAMU
Frequent Visitor
4 years ago

Creating a Bandwidth/Confidential chart

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 oth...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

MIRZAMU's avatar
MIRZAMU
Frequent Visitor
4 years ago

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