Forum Discussion
filter on a page usign USERNAME()?
- 3 years ago
That's correct, you cannot use the USERNAME or USERPRINCIPALNAME functions as a column in a table. However, you can use these functions in a measure to filter the data at the visual level. Here's how you can do this:
- Create a new measure using the USERNAME or USERPRINCIPALNAME function. For example:LoggedInUser = USERNAME()
Add the measure to the table or matrix visual that you want to filter.
Click on the visual and go to the "Format" tab in the top menu.
In the "Filters" section, click on the "Add" button.
In the "Add filter" window, select the measure that you created as the field to filter by.
In the "Filter type" dropdown, select "Advanced".
In the "Advanced Filter" window, select the operator and value for your filter. For example, you can use the "=LoggedInUser" measure to filter the data for the logged in user.
Click "OK" to apply the filter.
I hope this helps! Let me know if you have any questions.
- Create a new measure using the USERNAME or USERPRINCIPALNAME function. For example:
Anonymous , Please check reply from MatthRichardsUK first.
But as far as I am aware you can not use username and userprincipalname in a column. This means you have to create a measure and you can use measure only in the visual level filter, not page level.