Forum Discussion

sanjaymithran's avatar
sanjaymithran
Helper II
10 months ago
Solved

Matrix Table -Multiple columns image like below

Hi All, Need to create Matrix table like below,Please suggest Thanks in Advance
Need Help
  • MasonMA's avatar
    MasonMA
    10 months ago

    Well, if you have to create this type of visual you can always duplicate it in Power Query and make a table just for the use of this Matrix. 

MasonMA's avatar
MasonMA
Super User
10 months ago

sanjaymithran 

 

Hi, one of the ways would be first transform your data in Power Query by Unpivoting columns other than 'Region', 'Country' and 'Date' from 

to, 

Then in reporting, aggregate your Value with a SUM function, and use below sample DAX to Format them

Format=
VAR IsMargin = SELECTEDVALUE('Table'[Attribute]) = "Margin"
RETURN
IF (
     ISBLANK([ValueSum]),
     BLANK(),
     IF(
        IsMargin,
        FORMAT([ValueSum], "0.0%"),   -- Percent for Margin
        FORMAT([ValueSum], "$#,##0")  -- Currency for Sales/Profit
))

For the visual, use "Attribute" and Month Name for Columns, remove the name of "Attribute" from Column afterwards) 

 

 

 

 

 

  • sanjaymithran's avatar
    sanjaymithran
    Helper II
    10 months ago

    Hi,

    Thanks for the reply ,we can't use unpivot options because we have used other columns in report and Region ,country also used in diffrent report

    Tried Calculation Groups but not able to filters zeros and blanks

    • MasonMA's avatar
      MasonMA
      Super User
      10 months ago

      Well, if you have to create this type of visual you can always duplicate it in Power Query and make a table just for the use of this Matrix.