Date slicer: obtain start date and end date from calculated columns or measures

Status: New
by siacc Frequent Visitor ‎04-11-2017 08:32 AM - edited ‎04-14-2017 06:06 AM

Hi all,

 

I would suggest an idea to improve date slicer.

It could be beautiful if you could set start date and end date of the slicer with a value given from a calculated column or measure.

 

For example, it could be beautiful if you could set

 

Start Date = NOW()

End Date = Start Date + 15 days (or Start Date + 30 days, or StartDate + 7 days... And so on Smiley Happy )

 

End Date could change dinamically based to the Start Date Value (NOW()).

 

What do you think about?

 

Cheers.

Comments
by Moderator v-viig
on ‎04-14-2017 03:17 AM

Hello @siacc,

 

Thanks for your feedback.

Sounds good to me Smiley Happy

 

Do you want to apply this idea to Timeline custom visual or Slicer visual?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

by siacc Frequent Visitor
on ‎04-14-2017 03:20 AM

Hello @v-viig

I'd like to see it when you use a slicer as Timeline visual. Smiley Wink

Currently, this feature is not supported.

by Moderator v-viig
on ‎04-14-2017 03:39 AM

Thanks for the clarification.

We'll consider this feature in future versions of the visual.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

by Administrator chass
on ‎05-18-2017 10:02 PM

Pretty certain both have been done. 

Please see the time brush custom visual and the relative time slicer

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/

and 

https://app.powerbi.com/visuals/show/TimeBrush1450434005853

 

Idea Statuses