Compare row and column header in matrix chart

[DeepakJha23]

Hi PBI Community,

We have a requirement as below :

We are creating a slant chart in Power BI matrix chart . It compares the row header(Version) against the column header(Fiscal Week). 

If the row header is equal to column header then QTY. value should flow downwards to other rows till week 52 like below :

I would like to know how this can be achieved in Power BI. 

Thanks in advance.

@amitchandak  @olgad  @FreemanZ  @Sahir_Maharaj @Greg_Deckler 

[Anonymous · Accepted solution]

Hi @DeepakJha23 

You can create a measure 

Measure 2 = IF(MAX([Version])<=MAX([Fiscal Week]),MAX([QTY]),MINX(FILTER(ALL('Table'),[Version]<=MAX([Version])&&[Fiscal Week]=MAX([Fiscal Week])&&[Version]=[Fiscal Week]),[QTY]))

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.