Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply

Open Report showing only this month data

Hello everyone, 

I'm trying to limit the data my graphics show upon opening a report in reading view,

I need to have it sliced to show only the last month data when i first open the report

Desired upon opening the reportDesired upon opening the report

But i can only get the all data set date range

All data setAll data set

is there a way I can do this?
note: I'm new at Power BI

Please let me know.

 

Thanks in advance.



4 REPLIES 4
Anonymous
Not applicable

You can add the reading date to 'Filters on this page' (or 'Filters on all pages' if you want it on every page in the report)  and set the default date range here:

 

defaultdate.PNG

Thanks Jef, 
but i still need to be able to get the dates before that one, 

so on opening the report it shows only the data for this month, but the current user can still navigate to the other dates as well

Anonymous
Not applicable

Excuse me, I misunderstood your question. 

 

I've searched around for a bit and found this blog: https://powerpivotpro.com/2018/12/setting-a-default-slicer-selection/

I think the blog explains a solution to your problem in a clear and simple way.

 

Good luck!

 

 

Hello once again @Anonymous , thanks for all the suport up till now

I saw ur solution idea and i've been trying to make it work since yesterday, 
what he does in that blog is similar to what I want, but that doesn't actaully make the slicer value selected but just build a filter on the values.

I tryied something applying the measures :

Current Selections =
COUNTROWS ( DISTINCT ( ALLSELECTED ( 'Query2'[reading date]) ) )

and

Total Selections =
COUNTROWS ( DISTINCT ( ALL ( 'Query2'[reading date] ) ) )
But the last one, i can't apply to the final measure

 

Default Date =
IF (
[Current Selections] = [Total Selections],
    CALCULATE (
        MAX ( Query2[reading date] ),
        FILTER ( Query2, Query2[reading date] >= TODAY()-30)
    ),
    MAX ( Query2[reading date] )
)

Please advise.
 
Thanks


Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.