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.
Hello everyone,
I'm trying to limit the data my graphics show upon opening a report in reading view,
I need to have it sliced to show only the last month data when i first open the report
But i can only get the all data set date range
is there a way I can do this?
note: I'm new at Power BI
Please let me know.
Thanks in advance.
You can add the reading date to 'Filters on this page' (or 'Filters on all pages' if you want it on every page in the report) and set the default date range here:
Thanks Jef,
but i still need to be able to get the dates before that one,
so on opening the report it shows only the data for this month, but the current user can still navigate to the other dates as well
Excuse me, I misunderstood your question.
I've searched around for a bit and found this blog: https://powerpivotpro.com/2018/12/setting-a-default-slicer-selection/
I think the blog explains a solution to your problem in a clear and simple way.
Good luck!
Hello once again @Anonymous , thanks for all the suport up till now
I saw ur solution idea and i've been trying to make it work since yesterday,
what he does in that blog is similar to what I want, but that doesn't actaully make the slicer value selected but just build a filter on the values.
I tryied something applying the measures :
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |