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).    ...
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.

     

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.