Forum Discussion
Issue slicer date range
Hi all, I have a slicer date (option: before) from table DimTime(Time). (start date: 1/2/2017 and end date: 26/6/2017) I create meassure MaxDate = CALCULATE(MAX(DimTime[Time]), ALLSELECTED(DimTime...
Do you have data in the table DimTime that actually has 27/6/2017 data in it?
If none, then the measure is working properly.
I do not have data in 27/6/2017.
When I choose 27/6/2017, i want my measure result is 27/6/2017. Or do not allow choose 27/6/2017
Sorry, but I don't think that's how a measure works.
You either put in dummy data for 27/6 or resize the date slicer viz under Format > Text Size and then put in a "MaxDate" text box under or next to it.