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.
hi all,
i have the following table or matrix i want to present:
Case ID | Start Date | End date | Name |
001 | 01-01-2020 | 10-02-2020 | Mike |
002 | 10-01-2020 | 13-02-2020 | Lisa |
003 | 15-01-2020 | 15-02-2020 | John |
004 | 16-01-2020 | 16-02-2020 | Frank |
005 | 20-01-2020 | 20-02-2020 | Sarah |
006 | 30-01-2020 | 01-03-2020 | George |
I have added a indirect relation between start-date and my date table. When i want to add a date slicer (for example week number) the matrix or table doesn't change when i select fe only week 1 and 2 (case id 004, 005, 006 are still in the matrix). Any ideas how to link this kind of table or matrix with a date slicer?
thanks in advance!
Regards,
Frank
Hi @frankhofmans ,
Can you please share screesnhot of your data model here with relationships that you have created?
Thanks,
Pragati
hi Pragati,
i think i solved it. i used the following measure: Is in range = VAR r = CALCULATE( COUNTROWS(Data), USERELATIONSHIP( Date,start_date ) ) RETURN IF(ISBLANK(r), 0, r)
thanks for the quick response,
Regards,
Frank
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |