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
Whenever our user opens the dashboard the start date should show the completed month and
the end date show the current date.(for ex : lets consider today’s date ie.14th September so the start date should show “1 August 2022” and end date show “14 September2022”) .We used Date slicer with "between" as filter.
Whenever a user open the dashboard by default the date slicer should show the present month date.Forexample:
today's date is 22sep2022
in date slicer it has to show 1sep2022 to 21sep2022.
we are stuck in this as date slicer is showing by dafault 1jan2021 to today.
Do you use a calendar table? Is it in import mode? Is it refreshed daily?
If yes on all three then I can show you how to do that.
This date table is created in transform data .On service it is refreshed daily .
We achieved this before but other month's date get disabled(greyed out).
- create a calculated column in your calendar table that marks all dates in the current month until today
ThisMonthToDate = year([date])=year(today()) && month([date])=month(Today()) && day([date]) <= day(Today())
- use this column as a filter for your slicer.
The DAX which you have sent is working in the slicer but August month is greyed out.The user also want to select previous months.
If you always want the options to be from the 1st of the previous month to today you could ammend the calculated column to be:
LastMonthToDate =
[Date]> EOMONTH(TODAY(),-2)
&& [date] <= Today()
Teach them how to use the filter pane. They need to clear that filter
OK. What have you tried and where are you stuck?