Forum Discussion
Filter to current user by default
I'm trying to enhance a report such that, when the user first opens it, it is filtered to just show their data, but they can then easily flip between just their data, and that for everyone. I've ...
You can't have a measure in a slicer. A slicer is taking its data from a table.
Anonymous wrote:You can't have a measure in a slicer. A slicer is taking its data from a table.
Yes, that's my understanding, thanks for confirming. USERPRINCIPALNAME() can be used in a measures but not columns, and slicers and page/report level filters can use columns but not measures. It's like there's a wall between what the features/functions will do and the functionality I'm trying to achieve - very frustrating!