Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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