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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
alevandenes
Helper IV
Helper IV

Two slicers interactions possibilities

Hi Community,

 

I have a report with two slicers - one where you can select the name of a project and one where you can select the dates.

For both of the slicers i have set up Single select as i want my users to select only one project at a time and one date at a time.

 

alevandenes_0-1666768353478.png

I have two questions:

- is it possible to set Date created slicer to always display the latest value for dates? (this will change over time as more data is added in the background)

- when i select another project the date created will stay on the old selection, turning the whole report blank. For example, if i know move to Project 1234 that doesnt have Date create = 20 October 2022, but (let's assume) date created = 21 October 2022, the report will show blank cause i need to deselect 20 october and select 21 october manually. is there a way that i can avoid this?

 

Please let me know if more info is needed from my side.


Thanks a lot in advance

 

2 REPLIES 2
VijayP
Super User
Super User

@alevandenes 

https://community.powerbi.com/t5/Desktop/latest-date-in-the-slicer/m-p/890035#:~:text=You%20can%20us....

Try using this solution!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Hi! thank you for your answer. 

i seem to understand that if marked with "latest date" it will not show the date behind it..

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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