Forum Discussion

viswaaa's avatar
viswaaa
Helper IV
1 year ago
Solved

Matrix visual measures

Hi All,

 

I need to create a text chart like the one below.

I took a matrix and couldn't get this done.

 

 

Could any one please help how to do this

 

 

 IndiaAusCanada
Sales100200100
Profit204010
  • Hi viswaaa ,
    Thank you for sharing the screenshot! It looks like you're using a Matrix visual where Sales and Profit are currently displayed side by side as columns.
    If you'd like to arrange them vertically, one under the other, here's how you can do it:

    • Drag the Metric field (which includes Sales and Profit) from the Columns area.
    • Drop it into the Rows area, placing it below the Country field if it's already in the Rows section.
    • Make sure that the "Country" field is in the Columns section of your Matrix visual

    Expected output :

     

    Metric India Aus Canada
    Sales 100 200 100
    Profit 20 40 10

     

     

    If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

    If you continue to face issues, feel free to reach out to us for further assistance!

4 Replies

  • viswaaaCould you tell more in detail what you are getting the one you showed can be done in Matrix
    Did you try by , placing "Metric" in Rows, "Region" in Columns, and "Value" in Values. 

    • viswaaa's avatar
      viswaaa
      Helper IV

      Hi Akash_Varuna ,

       

      Please see below.

      And I am getting sales and profit side by side.But I need one under other.

       

       

       

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

        Hi viswaaa ,
        Thank you for sharing the screenshot! It looks like you're using a Matrix visual where Sales and Profit are currently displayed side by side as columns.
        If you'd like to arrange them vertically, one under the other, here's how you can do it:

        • Drag the Metric field (which includes Sales and Profit) from the Columns area.
        • Drop it into the Rows area, placing it below the Country field if it's already in the Rows section.
        • Make sure that the "Country" field is in the Columns section of your Matrix visual

        Expected output :

         

        Metric India Aus Canada
        Sales 100 200 100
        Profit 20 40 10

         

         

        If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

        If you continue to face issues, feel free to reach out to us for further assistance!