Matrix Display

Question

I have a matrix that compares Month over Month/Year over Year.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp;Feb&nbsp; &nbsp; &nbsp;March&nbsp; &nbsp; &nbsp; April&nbsp; &nbsp; &nbsp;May&nbsp; &nbsp;June&nbsp; &nbsp; &nbsp;July&nbsp; &nbsp; Aug&nbsp; &nbsp; Sep&nbsp; &nbsp; Oct&nbsp; &nbsp; Nov&nbsp; &nbsp;Dec&nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp;502022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75&nbsp; &nbsp; &nbsp; 75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; 75&nbsp; &nbsp;&nbsp;I would like to display only data from the prior year taht matches the month for the current year.&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp;Feb&nbsp; &nbsp; &nbsp;March&nbsp; &nbsp; &nbsp; April&nbsp; &nbsp; &nbsp;May&nbsp; &nbsp;June&nbsp; &nbsp; &nbsp;July&nbsp; &nbsp; Aug&nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp;&nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75&nbsp; &nbsp; &nbsp; 75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; &nbsp;75&nbsp; &nbsp; &nbsp; 75&nbsp;&nbsp;Is there a way this can be achieved?

amitchandak · Accepted Answer

Rocky_Brown , Create a measure and use in visual 
&nbsp;
if(Month(Max(Date[Date])) &gt; Month(Today()) , blank(), [Measure])
&nbsp;

Forum Discussion

Matrix Display

2 Replies

Related content

display total in matrix visual

Display row in matrix

Matrix column headers display

Matrix table

Power BI Matrix Expand/Collapse Button Display