Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])