The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi, how would you filter a detail table, where a user chooses a start and end date from a drop down, and all you want to see are the records that fall within that range?
Create a measure like:
ShowRecord = IF(Table2[Date] >= [StartTime] && Table2[Date] <= [EndTime], 1)
and then use that as a visual-level filter on the table.
User | Count |
---|---|
69 | |
64 | |
62 | |
54 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
42 |