Forum Discussion
Solved
Matrix Visual: Show Last Two Months and Overall Total
Dear all, I am trying to solve the following problem with a matrix visual. I do have a dataset with costs per month, but in the matrix visual, I only want to show the recent two months, and totals....
Hi tlo11 ，
I make a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
tlo11 , You can use relative date slicer or same option in visual level filter
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Hey there,
thanks for your reply. While it does filter to the recent two months, the total will only show that of the months filtered and not the whole calender year
