To create date table for the week based on date selected from slicer

Question

&nbsp;I am trying to create two tables in Power BI report based on a date selected from the slicer. The first table needs to have dates for all days of the week belonging to the selected date. The second table needs to have all the dates of the previous week. Please help me to achieve this,&nbsp;

v-jiascu-msft · Accepted Answer

Hi kamalmsharma,
&nbsp;
I hope you mean the table visual rather than the calculated table, which doesn't respond to the slicer.&nbsp;
Please download a demo from the attachment.&nbsp;
1. Create a slicer table without any relationship to other tables.
2. Create two measures.
thisWeek =
VAR selectedDate =
    SELECTEDVALUE ( 'SlicerTable'[Date] )
RETURN
    IF (
        ISBLANK ( selectedDate ),
        BLANK (),
        IF ( WEEKNUM ( MIN ( 'Table'[Date] ) ) = WEEKNUM ( selectedDate ), 1, BLANK () )
    )

previousWeek =
VAR selectedDate =
    SELECTEDVALUE ( 'SlicerTable'[Date] )
RETURN
    IF (
        ISBLANK ( selectedDate ),
        BLANK (),
        IF (
            WEEKNUM ( MIN ( 'Table'[Date] ) )
                = WEEKNUM ( selectedDate ) - 1,
            1,
            BLANK ()
        )
    )

3. Either adding the measures in the table or putting in the Visual Level Filter.

&nbsp;
&nbsp;
Best Regards,
Dale

Forum Discussion

To create date table for the week based on date selected from slicer

2 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Between date slicer - calender selection