Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago
Solved

Matrix Rows Based on Date Slicer

Hello community,

 

Is it possible to have a date slicer dynamically changing a Matrix rows?

 

For instance: if min date of slicer is 28/nov/18 (today) Matrix rows should displays all days of last week. 

 

Sample : https://drive.google.com/open?id=1CzKayMIk99I3JJ4qH7mhEILIuW3nF4Ns

 

Thanks in advance

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Fcoatis

    To workaround this,

    1.create a new table as a new calnedar table used in slicer.

    enter in "New Table"
    slicer table = CALENDAR("01/01/18","12/31/18")

    Create calculated columns in this table
    Weeknum = WEEKNUM([Date],2)
    2. add 'slicer table'[date] in the slicer instead of Calendar[date].
    create measures in  'slicer table'
    min selected = MIN('slicer table'[Date])

weeknum_selected = WEEKNUM([min selected])

weeknum_selected-1 = WEEKNUM([min selected])-1

LastWholeWeek = IF(MAX('Calendar'[Weeknum])=WEEKNUM([min selected])-1,1,0)
    3. add in Visual level filter as below
     
    Finally, 
     
    Please see my solution in Page5
     
    Best Reagrds
    Maggie

6 Replies

    • Fcoatis's avatar
      Fcoatis
      Post Patron
      7 years ago

      Thanks for the suggestion,

       

      but I have a Visual that depends on current date slicer filter, I wanted the other one (Matrix) to dynamicaly change rows.

       

      Best regards

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        7 years ago

        Hi,

        i think you have to think different. :-)

        The date slicer filters on page level and should return the date range.

        The more granular filter for the visual, you should set on the visual level.  (Maybe with a Top filter on Date.)

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Fcoatis

    To workaround this,

    1.create a new table as a new calnedar table used in slicer.

    enter in "New Table"
    slicer table = CALENDAR("01/01/18","12/31/18")

    Create calculated columns in this table
    Weeknum = WEEKNUM([Date],2)
    2. add 'slicer table'[date] in the slicer instead of Calendar[date].
    create measures in  'slicer table'
    min selected = MIN('slicer table'[Date])

weeknum_selected = WEEKNUM([min selected])

weeknum_selected-1 = WEEKNUM([min selected])-1

LastWholeWeek = IF(MAX('Calendar'[Weeknum])=WEEKNUM([min selected])-1,1,0)
    3. add in Visual level filter as below
     
    Finally, 
     
    Please see my solution in Page5
     
    Best Reagrds
    Maggie