Forum Discussion

kamalmsharma's avatar
kamalmsharma
Icon for Helper II rankHelper II
8 years ago
Solved

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

 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 ...
  • v-jiascu-msft's avatar
    8 years ago

    Hi kamalmsharma,

     

    I hope you mean the table visual rather than the calculated table, which doesn't respond to the slicer. 

    Please download a demo from the attachment. 

    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.

    To_create_date_table_for_the_week_based_on_date_selected_from_slicer

     

     

    Best Regards,

    Dale