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

Default Date on Report

I have a report that displays total market value for a list of accounts.  The report supports the ability to select a date to see current or historical market values based on date selected in slicer.  Is it possible to default the report so it defaults to the latest date but still give the end user the ability to change the date if they want to see a historical number.  I am trying to prevent the scenario where no date is selected and the total market value is the sum of all dates available.

2 REPLIES 2
JordanAWARE
Frequent Visitor

Re: Default Date on Report

Hey is it possible to get a screenshot to see how the date/historical data is setup?

 

Or in your historical calculations you could try add an is filtered:

 

if ( ISFILTERED('Date'[date],
calculate stuff with filtereddate,

calculate stuff to show with no date filters)

 

Not sure if something like this will work with your calculations but it is specifiying what to calculate when there is no date filter - which is where you would just calculate your 'default' date

Community Support
Community Support

Re: Default Date on Report

Hi @CJANE,

 

Current slicer not support setting default value, I think you can vote below idea which has the similar requirement:

Default Selected Slicer or Tile-By Value Configuration

 

Regareds,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors