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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors