Issue slicer date range

[pmhoang94]

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))

My issue is:

 - If I choose date is 26/6/2017, maxdate is 26/6/2017. It is true.

- If I choose date is 27/6/2017, maxdate is 26/6/2017. It is false.

I want to maxdate display correct date choosed. Or only choose date range start date: 1/2/2017 and end date: 26/6/2017 (not allow choose 27/6/2017)

Can anyone help me?

[Anonymous]

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.

[pmhoang94]

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

[Anonymous]

Refer here:

http://community.powerbi.com/t5/Desktop/Limit-Time-slicer-values-to-the-range-that-is-in-the-dataset...

[Anonymous]

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.