cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Frequent Visitor

Re: Date Label Slicer

@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
Highlighted
Microsoft
Microsoft

Re: Date Label Slicer

@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

Highlighted
Frequent Visitor

Re: Date Label Slicer

@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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors