Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am building a two-page report in desktop with the first page showing summary project figures - count of customers, total sales, mean sales per month etc. - while the second page needs to show the same measures restricted to the team for the logged in user.
If I apply role based filtering, both pages get filtered and so show only the figures for the logged in user's team, but I can't apply page level filtering based on a dynamic value ..... so I guess I am missing something in how to solve this problem in Power BI.
In effect, I want to set the page level filter to be "MyTeam" where "MyTeam" is the name of a measure.
Any help much appreciated.
Solved! Go to Solution.
Hi @BeeBeeJay,
Until now, we can't add measure in Page level filter, please review this feature request and vote it.
Best Regards,
Angelia
Yes, until now you cannot apply measure filter on the page level.
Here a great video on how to use measure filters:
https://www.youtube.com/watch?v=Ss5L7jXIhso
Hi @BeeBeeJay,
Until now, we can't add measure in Page level filter, please review this feature request and vote it.
Best Regards,
Angelia
Thanks for highlighting that. Have voted for it.
You might be able to solve that with the disconnected table trick.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |