Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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)
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)
Thank you Maggie,
That´s what I was trying to figure out.
Kind regards.
Fabio Coatis
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
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
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
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.)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |