Forum Discussion

saben02's avatar
saben02
Frequent Visitor
3 years ago

create a period segment between two dates

Hello !  I created a segment to choose a period to display my data in a visual table : My problem is that the "between" style requires me to choose a day, a month and a year, whereas in my ca...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi saben02 ,

 

According to your data model, I think your issue should be caused that 03/01/2017 is not in range 03/25/2017 to 05/25/2017 and there is only 03/01/2017 in your data model. So Power BI couldn't find date in March, it will return 04/2017. Here I suggest you to create a calendar table by CALENDAR() or CALENDARAUTO() function which with continuous date.

Then your measure should look like as below.

choix seg date P1 onglet cumul =
IF (
    ISFILTERED ( 'Calendar'[Date] ),
    "From " & FORMAT ( MIN ( 'Calendar'[Date] ), "MM/YYYY" ) & " to "
        & FORMAT ( MAX ( 'Calendar'[Date] ), "MM/YYYY" ),
    "All the period"
)

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • saben02's avatar
    saben02
    Frequent Visitor
    3 years ago

    Hello, thank you so much for your reply.

    This method solves my display problem but still doesn't show the data for the corresponding periods.

     

    Indeed , if the user chooses a date other than the first of the month, I want it to display only the data for that month.

    But here when I choose January 2, 2017 on my slicer, for example, it will take into consideration the data for the following month, i.e. February. ☹️