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
6 REPLIES 6
Highlighted
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
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

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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 265 members 3,018 guests
Please welcome our newest community members: