Without selection previous quarter in pie chart dynamically

[Subba55]

Hii Guys,

I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user open the dashboard ,with selection it's show accordingly.

Can help me this anyone please.

Thanks in advance.

Regards,

Subba

[Vegar]

Assuming you have a date field, Date, and a value field, Amount, in your data model. if not then adjust my suggestion to your data model.

Sum({<[Date]={">=$(=quarterstart(max([Date]),-1))<=$(=quarterend(max([Date]),-1))"}>}[Amount])