Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hey all! It's me again.
I've found all kinds of answers for this that almost fit. So, if I'm just not seeing a way to make the existing solutions work, please let me know.
I have a data table with info for about 400 days.
I have a dates table with an even wider range of dates (it comes from a SQLServer DB, as its own table).
I would like to have a slicer that gives me access to all 400 days, but that defaults to a date range of the last 30 days. It *should* be able to say that the "end date" of that range is always "today".
I can get the date range to be dynamic, for the last 30 days. But, after 30 days "back" I can't select dates.
I can make a dynamic table for dates, that is limited to TODAY()-400, so I have the dynamic part of it, but the slicer shows, by default, all 400 days of data.
So. Is there a way to make the slicer show (e.g., 10/1/2022-10/31/2022) even though my data goes back to 2021?
Thanks!
Solved! Go to Solution.
Ditch the slicer. Use visual, page or report level filters. Set them to Relative Date - "Last 30 days". Allow your users to modify filters. Teach them how to do that.
So I guess that's where I'm confused. I have a calculated table of the last 400 days.
I want all 400 days available in the event the customer needs to look at it. But they need to see ONLY the last 30 days when they first load the report.
Anything I do to accomplish seeing only the last 30 days prevents me from looking back beyond 30 days even with the calculated table in the mix.
so I'm missing that final piece of the puzzle--how do I show only the first 30 days but still allow my customers to choose older dates?
Ditch the slicer. Use visual, page or report level filters. Set them to Relative Date - "Last 30 days". Allow your users to modify filters. Teach them how to do that.
If your data sources are accessed in import mode and refreshed daily then you can add a calculated table that can do that for you.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |