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,
I have a report with two visuals. One of those visuals should be filtered to show only transactions for the week selected in the date slicer, the other visual needs to show all transactions up to the date of the slicer.
For example in the below. the cash variance should only show transactions with w/e/ date 01/04/18, but the unbanked visual should be all transactions up to 01/04/18;
Any help would be appreciated.
Thanks,
Craig
Hi @CraigDon,
There is a function "Edit interactions" that can block the filtering of the slicer. But maybe you need a measure to workaround the slicer. Please share a dummy sample in order to write down the DAX formula. It could be something like this. (just a pseudo-code)
Measure = calculate(if(unbanked[date] < max('date'[rptdatewekend]), 1, 0), all('date'))
Best Regards,
Dale
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |