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.
Is this possible in some way?
I need my date slicer to be dynamic to the user, but also default to show last 30 days like this:
Above is for today when the user opens the report. below is tomorrow:
I have searched the internet without luck.
Solved! Go to Solution.
My solution is to use a relative date slicer and below that a date slicer that reacts / filters to the relative slicer. Not pretty but doable for now
My solution is to use a relative date slicer and below that a date slicer that reacts / filters to the relative slicer. Not pretty but doable for now
@Bokazoit , You can not. The best is that you can use a relative date slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
or you can create a column like this in your date table and use
Is Last 30 = if('Date'[Date]>=TODAY()-30 && 'Date'[Date]<=TODAY(),"Today",[Date]&"")
That requires the user to always choose relative dates or be active on a specific date!? That is so weird. I can either be using the report on time or not use it.
I have a user group that prefer last 30days but on a non defined day would like to see the development between to different dates and that does the relative not support 😞
Really not satisfying. I know You are not to blame but it is a totally normal procedure in a modern company to see a default periode and choose their own! It is even a standard Microsoft functionality on SSRS 😵😠
@Bokazoit , There are a few ideas already there for it. Have a relative date slicer with the date and initialize date.
You can check and vote or log a new one https://ideas.powerbi.com/ideas/
also refer if this can help
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |