Sam1

I think this might help, I'd need more details to know if that would answer your question. You could also try a beast mode if you're trying to do something else, again we'd need more and specific details to help.

I don't believe this is possible. If you had applied the filter from a filter view (this is a beta product, talk to your CRM if you want it) then you could have changed the filters applied to each page and saved those, instead of card by card. You could also create a new dataflow for the underlying dataset for those cards…

I think you'd need to do that with two separate beast modes; one like this: case when Transaction = 1 then sum(sum(`Amount`)) over (partition by year(`Posting Date`)) end and one like this: case when Transaction = 0 then sum(sum(`Amount`)) over (partition by year(`Posting Date`)) end You may need a third for the total…

Found the answer here. I just needed to set the Category Scale (X) | Never Use Time Scale property to True.