Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a page in powerbi that has a page level filter - this filters all of the kpis and metrics to show data for a single week (start_of_week. The user can select which week data to view using the filter.
However I want to add a multi label cards so that the kpis for this week are shown, but underneath has the change (be it a % change or volume change) compared to last week.
Is it do-able to write measures that will ignore the page filter and do the same measure but for start_of_week - 7?
Update - I've managed to make a measure that ignores the column filter using REMOVEFILTERS, however I don't know how I'd then apply another filter to the measure to get the data for start_of_week - 7?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |