cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fcoatis Member
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Matrix Rows Based on Date Slicer

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
12.png
 
Finally, 
11.png
 
Please see my solution in Page5
 
Best Reagrds
Maggie

View solution in original post

6 REPLIES 6
mwegener Member
Member

Re: Matrix Rows Based on Date Slicer

Hi,

 

I think you can use a relative date slicer for this.

 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 

Fcoatis Member
Member

Re: Matrix Rows Based on Date Slicer

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

Re: Matrix Rows Based on Date Slicer

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

Community Support Team
Community Support Team

Re: Matrix Rows Based on Date Slicer

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
12.png
 
Finally, 
11.png
 
Please see my solution in Page5
 
Best Reagrds
Maggie

View solution in original post

Fcoatis Member
Member

Re: Matrix Rows Based on Date Slicer

Thank you Maggie,

 

That´s what I was trying to figure out.

 

Kind regards.

 

Fabio Coatis

Highlighted
Fcoatis Member
Member

Re: Matrix Rows Based on Date Slicer

Just for those interested in my adaptation of Maggie´s solution, I´m sharing the knowledge.

 

Thank you guys.

 

https://drive.google.com/open?id=1MnQ5HzmCs37oK3oXbNM13kiQOW-R2H_6

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 479 members 3,637 guests
Please welcome our newest community members: