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.
apologies if this is easy stuff, but I'm new...
I have two unrelated tables so I can't build a relationship to enable cross-grid filtering.. so...
Top grid has a table of dates and event names. I'm using the table preview visual so I can select a row in this grid.
The bottom grid links to a second table has a range of dates (start Date and End Date). By default bottom grid currently shows all rows because there is no obvious relationship, but what I want to do is set up a filter that says only show rows WHERE (date selected in Top grid is BETWEEN startDate and EndDate)..
Is there a DAX expression I can use for filtering the bottom grid based on what's selected in the top grid? (again, using the preview data table visualization)..
thx..
M...
Solved! Go to Solution.
You can create a measure in Table 1 for "Selected Date".
Selected Date = MAX('Calendar'[Date])
Then create a "Tag" measure to check if current row date range cover the "Selected Date".
IsWithinRange = IF([Selected Date]>=CALCULATE(MAX(Duration[StartDate])) && [Selected Date]<=CALCULATE(MAX(Duration[EndDate])),1,0)
Add above measure into Visual Level Filter, make it equals to 1.
Regards,
You can create a measure in Table 1 for "Selected Date".
Selected Date = MAX('Calendar'[Date])
Then create a "Tag" measure to check if current row date range cover the "Selected Date".
IsWithinRange = IF([Selected Date]>=CALCULATE(MAX(Duration[StartDate])) && [Selected Date]<=CALCULATE(MAX(Duration[EndDate])),1,0)
Add above measure into Visual Level Filter, make it equals to 1.
Regards,
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |