Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |