Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


Last value in Slicer


Nice day

Can you support me with a question please?
Is there a way that using the slicer / Slicer the last value is shown at the time of updating the report?
since when opening it always shows the last data with which it was published, but not the last value,
I understand that it can be by relative date, but a single selection is required to analyze the data of the last period without losing the possibility of visualizing in a unique way backwards.
Last Business Date =
SemanasOneContact[fechaInicio] <= LASTDATE(ALL(Financial[Date]))

Greetings and thanks in advance.


Nice day

The detail is that I use a gateway to update the dataset, and each time it is updated, the slicers show the value with which the report was saved, and the expected result is that it shows the last value in the slicer.

Thank you for your comments and time.

Community Support
Community Support

Hi @Syndicate_Admin ,

I'm a little confused about your needs, Could you please explain them further? 

Thanks for your efforts & time in advance.


Best regards,
Community Support Team_ Binbin Yu

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors