Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
anuja07
Frequent Visitor

Whenever I open the PBI file in services the date should show default.

Date Slicer.png

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.

8 REPLIES 8
anuja07
Frequent Visitor

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.

August greyed out.jpgcommunity-1.jpg

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.

Anonymous
Not applicable

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 

lbendlin
Super User
Super User

OK. What have you tried and where are you stuck?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors