Last day selected in slicer

[Syndicate_Admin]

Hello I need help, I do not know how to leave selected the last available day (or yesterday) in a data slicer, but that are available in the segmenter the rest of the days, bone that in the data segmenter are available every day, but the last selected day appears.

I would appreciate any suggestions, a greeting.

[speedramps]

Hi Syndicate_Admin

 

Most Power Bi novices dont understand how slicers works.

The create single selection and publish the report on 3May2022,
and expect Power BI to magically Mmove the slicer forward each day to 4May2022, 5May2022, 6May2022 etc.

But the report will default to 3May2022 for ever ☹️

See this solution 

https://www.youtube.com/watch?v=VaJ10ilXp6Y

I have helped you now please help me with kudos.
Click the thumbs up if you like me trying to help you.
And click Accept As Solution if I have fixed your problem.
One problem per ticket please. If you need to expand or change your problem then please accept this solution and raise a new ticket.

[SpartaBI · Accepted solution]

@Syndicate_Admin hey, this is a great video on how to do that:
https://www.youtube.com/watch?v=VaJ10ilXp6Y

[Syndicate_Admin]

Thanks for answering, it is a very good video, but it gives me a problem,

I think so:

Table Dates =

ADDCOLUMNS (

CALENDARAUTO(),

"Date ID", FORMAT ( [Date], "YYYYMMDD" ),

"Year", YEAR ( [Date] ),

"My", FORMAT ( [Date], "MM" ),

"Period", FORMAT ( [Date], "YYYY-MM" ),

"Periodo2", FORMAT ( [Date], "YYYY/mmm" ),

"Short Month Name", FORMAT ( [Date], "mmm" ),

"Number My", FORMAT ( [Date], "mmmm" ),

"Day Week number", WEEKDAY ( [Date] ),

"Day Week", FORMAT ( [Date], "dddd" ),

"Short Week Day", FORMAT ( [Date], "ddd" ),

"Quarter", "Q" & FORMAT ( [Date], "Q" ),

"Year/quarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),

"Slicer Date",

IF(

[Date]=TODAY(),

"TODAY",

IF(

[Date]<TODAY(),

[Date]&""

)

)

)

And if it appears in the slicer "TODAY" but the days appear in text "MONTH-DAY-YEAR and does not let me order them.

What can I be doing wrong?

Thank you.

[SpartaBI]

@Syndicate_Admin hey, he actually address this specific issue in the video 🙂 let me know if you found it.

P.S. In case it solved your question please mark it as a solution for community visabilty

[Syndicate_Admin]

thank you very much, my problem is that I do not speak English, and I have a hard time fully understanding the video, I will continue to analyze the video to see if I understand what I am doing wrong, thank you very much.