Forum Discussion

sanjaymithran's avatar
sanjaymithran
Helper II
11 months ago
Solved

Matrix Table -Multiple columns image like below

Hi All,

Need to create Matrix table like below,Please suggest

Thanks in Advance

  • MasonMA's avatar
    MasonMA
    11 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. 

8 Replies

  • 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

      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

        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. 

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support

    Hi sanjaymithran,

    Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to MasonMA & amitchandak  for sharing valuable insights.

     

    Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

     

    Thank you for being part of the Microsoft Fabric Community.

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support

    Hello sanjaymithran,

    Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

    Thank you.

  • Hi,

    Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support

    Hello sanjaymithran,

    We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

    Thank you.