Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have a timeline slicer based on the last day, but users can select 7 days before
I would like each day the slicer is in the last day.
When a user enter in the report, it is on the last day, but he can change on an onther day if we wants
How can I handle that ?
Assume that you have a calendar table, you can create a column using the DAX below, then create a slicer using this column, and select “Yesterday” in the slicer.
Day = IF( DateTable[Date] = TODAY() - 1, "Yesterday", DateTable[Date])
Another option is to create a measure calculating the value of last day, and put the measure into a card. After that, click on the Timeline slicer, select “Edit interactions”, choose “None” in the card visual. This way, when users select days in the timeline slicer, the card visual will not be filtered.
Yesterday Measure =CALCULATE ( SUM ( yourTable[Column] ), FILTER ( ALL ( yourTable), RELATED ( DateTable[Day] ) = "yesterday" )
Regards,
Lydia
That doesn't work
@Nibz,
Please use the DAX below instead, then create a slicer using this column and set its value to 1.
Yesterday= IF( Reservation[Start] = TODAY() - 1, 1, 0)
Regards,
Lydia
I am sorry, it is still not goof for me.
The new column is ok but it is not possible to select the 1.
@Nibz,
Please make sure that your date column contains the yesterday's date, otherwise you would only get 0 in the calculated colum.
Regards,
Lydia
Yes I am sure
@Nibz,
I am not able to reproduce your issue in my Desktop, would you please share the data of the Date column for me to test?
Regards,
Lydia
Ok but how can I send you the spreadsheet ?
@Nibz,
You can upload your file to OneDrive and post the shared link of the file.
Regards,
Lydia
I don't have onedrive...
I send you my email address via Private message, you can share the file via Email.
Regards,
Lydia
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
110 | |
109 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |