cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DataUPBI Frequent Visitor
Frequent Visitor

Dates shown based on the Slicer Selection

Hi,

 

I have 2 cards shown as StartDate and EndDate. These are associated to actual date fields and shown the actual dates when slicers are selected at detailed level. Now the problem is that there is a slicer for month like Jan, Feb, Mar, Apr. If none of the slicers are selected the StartDate should pick the first day of the earliest month and EndDate should pick last day of the latest month. For example for above 4 months StartDate is 1st Jan 2018 and EndDate is 30th Apr 2018. If any slicer is selected then it should show the actual dates. Is there a way to get this done?

2 REPLIES 2
Super User
Super User

Re: Dates shown based on the Slicer Selection

Images of what you are seeing and wanting to accomplish might help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Seems like you could just use a measure or default aggregation MIN and MAX though.


Check-out my Back to School contest submission: Dinosaurs!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

DataUPBI Frequent Visitor
Frequent Visitor

Re: Dates shown based on the Slicer Selection

Hi, please see the below sample data and what I want. 

 

Sample Data:

Data Sample.GIFWant1.GIFWant2.GIFWant3.GIF

Helpful resources

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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 255 members 2,526 guests
Please welcome our newest community members: