Month on month Actual v Predicted

[mloc1990]

Hi 

I'm using the matrix visual to display month on month figures for Processed vs Estimted Volume. Is there a way to only show the processed volume when the month is over and predicted for the rest of the months?

Currently it is displaying a comparison for every month that has passed.

thanks,

[v-lid-msft · Accepted solution]

Hi @mloc1990 ,

Based on your sample data, I do some test and I think you can try to turn off the "show it items with no data" in the matrix.

If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

BTW, pbix as attached.

Best regards,

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more