cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dobregon Member
Member

Slicer "dates" not take automatically the last day in database

Hi,

 

I'm using a slider for Dates like this picture of today.dates.PNG

 

 

I have a datasource with daily values for lot of elements and the slicer is used for filter the dates to analyze. The problem is when  I publish the report (and configure the gateway in order to be refreshed every day) the last day of the slicer doesn't update to the last day in the database.

 

For example. Today i have values in the database for the 20th of August. I configure the visuals of the report an everthing and as i do today the last day in the slicer is the 20th.

 

I publish the report and stablish the gatewey and schedule refresh. The problem will be tomorrow when the report will be refreshed that the last day in the slicer will be the same 20th August instead of the 21th august.

Can someone helpme on that?
Regards!

 

 

 

6 REPLIES 6
Community Support Team
Community Support Team

Re: Slicer "dates" not take automatically the last day in database

hi, @dobregon

     You may try to set the date slicer to relative date slicer like below:

13.PNG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
dobregon Member
Member

Re: Slicer "dates" not take automatically the last day in database

thanks @v-lili6-msft it is a solution for people that want to have something like "from the 1st day of the year to the last day that i have" but the problem is that I need whatever day of start date and whatever day of end date (for that I take the decission to take from date to date) but automatically i want that the end date was the last day of my datasource.

In other slicers from marketplace, if I dont push any filter the system takes everthing without filter, but in the slicer default of PowerBI I can't do that and I need it

dobregon Member
Member

Re: Slicer "dates" not take automatically the last day in database

any new idea? i have tried different things but don't seem to be working

salta Frequent Visitor
Frequent Visitor

Re: Slicer "dates" not take automatically the last day in database

Hi

I have the same problem. I need to show the scrollbar of the slicer and the calendar "since" and calendar "to" too.

 

I need that the bar of "Date Range" can move itself autmomatically
when I refresh dashborad to current date.
For example if Last update now is 28/09/2018 11:17:02 AM I need to see
 the bar on date 28/09/2018 automatically and not manually.
Can you give me any suggestion about? Thanks. Regards.
 
dobregon Member
Member

Re: Slicer "dates" not take automatically the last day in database

Hi @salta

The only "solution" that I have found for now is to use a slicer from marketplace called "Hierarchy Slicer". In this slicer you put your list of dates (that will be increasing day by day in your database) and if you don't select any date in the slicer the system will use automatically all the dates uploaded in your datasource taking the lastest days, of course.

 

It is not the best solution becasue it is not easy to select from date to date but.... it is the solutions that I can tell you.

Maybe in the future (i hope) someone can give us a solution

souldiv Frequent Visitor
Frequent Visitor

Re: Slicer "dates" not take automatically the last day in database

I have that same issue with date slicers.

I have captured the query that should refresh the slicer period (you can see the query enabling PBI performance analyzer)

The final part of the query shows the dax code is correct (In my case I have 2 additional filters)

 

EVALUATE
SUMMARIZECOLUMNS(
__DS0FilterTable,
__DS0FilterTable2,
"MinOrder_Date", IGNORE(CALCULATE(MIN('Logistics Order'[Order Date]))),
"MaxOrder_Date", IGNORE(CALCULATE(MAX('Logistics Order'[Order Date])))

 

In my opinion there is bug with the presentation (between option)

If you are using sliders the righ side is never the maximum date

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 3,280 guests
Please welcome our newest community members: