- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-28-2018 12:41 PM
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
Solved! Go to Solution.
Accepted Solutions
Re: Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-30-2018 01:29 AM
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)
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)
All Replies
Re: Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-28-2018 12:59 PM
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
Re: Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-28-2018 01:04 PM
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
Re: Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-29-2018 01:20 AM
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.)
Re: Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-30-2018 01:29 AM
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)
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)
Re: Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-30-2018 03:43 AM
Thank you Maggie,
That´s what I was trying to figure out.
Kind regards.
Fabio Coatis
Re: Matrix Rows Based on Date Slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-01-2018 12:03 PM
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