Forum Discussion
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. However, the totals should be totalling over the whole year- but when I do filter the matrix to the recent two months, the totals update accordingly and only show the sum of the recent two months. Any chance this is possible?
Hi tlo11 ，
I make a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
5 Replies
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
Hey there, do you have the DAX code for this?
Hi tlo11 ，
I make a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
