Matrix Visual: Show Last Two Months and Overall Total

[tlo11]

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?

[Anonymous · Accepted solution]

Hi @tlo11 ，

I make a sample pbix file(see attachment) for you, please check whether that is what you want.

Best Regards

[VijayP]

@tlo11 

Let me know if you require This way, gif file attached

[tlo11]

Hey there, do you have the DAX code for this?

[amitchandak]

@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

[tlo11]

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