I am referencing a Project table and limiting the data to return projects that only match the user email.
No problem with the slice.
The issue is when I attempt to order the drop down results alphabetically. The expression returns project IDs that donโt belong to the email I am using.
My order by formula is ORDERBY(Projects[Project ID],[Project Name],FALSE).
When I remove the orderby expression, the drop down list displays a list I expect but not on alphabetical order.
What am I missing?!
Screen Shot 2021-08-06 at 5.40.27 PM|690x354
Solved! Go to Solution.
Because youโre using the base Table โProjectsโ in your expression, instead of the Slice โProject Slice Emailโ.
Because youโre using the base Table โProjectsโ in your expression, instead of the Slice โProject Slice Emailโ.
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |