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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JP_M_Shep
Frequent Visitor

Date Label Slicer

Hi

 

We have a great number of PowerBI reports that use Week, Month (aka Period) and Year as Date Slicers.

 

The reports are backed by Tabular models that link down to Day.

 

We have had the request could we a slicer on reports displaying by date label, so in the background Week, Month and Year are already assumed in the logic.

 

These are the business requirements:

 

1) Reporting Week - the last complete week that has finished
2) Reporting Month - if in the first week of the month then last month otherwise the current month
3) Reporting Quarter - if in the first week of the quarter then last quarter otherwise the current quarter
4) Reporting Year - if in the first week of the year then last year otherwise the current year
5) Month To Date - if in the first week of the month then last month otherwise complete weeks of this month to the end of last week
6) Quarter To Date - if in the first week of the quarter then last quarter otherwise complete weeks of this quarter to the end of last week
7) Year To Date - if in the first week of the year then last year otherwise complete weeks of this year to the end of last week
😎 Current Week - the week we are currently in

Last Year equivalents of the above
Next Year equivalents of the above

 

This much like SSRS where you can set date ranges to be chosen by for example - "Current Week", "This Quarter YTD", "Reporting Month Last Year"

 

Cannot find a good example for SSRS but this article kind of shows what i mean - https://stackoverflow.com/questions/33151162/date-range-as-parameter-in-ssrs-using-mdx

 

A few years ago, SQLcentral had an article on predefined date ranges you could build into an SSRS so only one date range parameter is visible showing like "Current Week", "This Quarter YTD", "Reporting Month Last Year"

 

Any help would be useful ...

1 ACCEPTED SOLUTION
afox723
Advocate II
Advocate II

@JP_M_Shep, this article may help.  Although it doesn't have the exact same periods as what you are looking for, the process is easily customizable to suit your needs.  I have used this for several reports and my users find it useful.  http://analyticsavenue.com/power-bi-timeperiod-slicer-for-last-7-dayslast-30-days/

View solution in original post

2 REPLIES 2
afox723
Advocate II
Advocate II

@JP_M_Shep, this article may help.  Although it doesn't have the exact same periods as what you are looking for, the process is easily customizable to suit your needs.  I have used this for several reports and my users find it useful.  http://analyticsavenue.com/power-bi-timeperiod-slicer-for-last-7-dayslast-30-days/

v-haibl-msft
Microsoft Employee
Microsoft Employee

@JP_M_Shep

 

There is no such built-in function in Power BI now. You can vote on following similar idea and add comments in it. 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19321789-dynamic-date-slicer-impr...

 

Another possible workaround is to create some Label columns using DAX as this document. You need to define the label based on your definition.

 

Best Regards,
Herbert

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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