Forum Discussion

DeepakJha23's avatar
DeepakJha23
Icon for Helper I rankHelper I
3 years ago
Solved

Compare row and column header in matrix chart

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 

 

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.