Forum Discussion

yeLc06's avatar
yeLc06
New Member
7 months ago
Solved

Matrix table

Hi, is this possible to do in matrix table

my current setup is two separate tables then hide the region store and product for the 2nd table.

is there a way to have 1 only table for this

sample  : 

 

 

Thanks.

 

  • d_m_LNK's avatar
    d_m_LNK
    7 months ago

    To my knowledge there is not a way to accomplish this with the matrix visual.  Since you want to group some and not all of the measures by Month-year, that is the main issue I see.  You would have to have all of the measures grouped under each month-year heading.  Creating two separate tables would be how I would do this.  Is there a specific need to have it in one contiguous table? Splitting it out may give you more flexibility/readability since the two sections seem to be measuring different things anyway.

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 months ago

    You will run out of screen real estate very quickly. Scrollbars on a visual are a design red flag, especially horizontal ones.

     

    If you need Excel style functionality then keep using Excel.

  • d_m_LNK's avatar
    d_m_LNK
    Super User
    7 months ago

    To my knowledge there is not a way to accomplish this with the matrix visual.  Since you want to group some and not all of the measures by Month-year, that is the main issue I see.  You would have to have all of the measures grouped under each month-year heading.  Creating two separate tables would be how I would do this.  Is there a specific need to have it in one contiguous table? Splitting it out may give you more flexibility/readability since the two sections seem to be measuring different things anyway.

  • techies's avatar
    techies
    Super User
    6 months ago

    Hi yeLc06

     

    This is just for reference from my financial data project. Instead of using multiple tables, I’ve used a single Matrix visual where Month Year and Row Labels are placed in the Columns area, PnL Line is in Rows, and the values are driven by a single measure (PnL Value).

    PnL Line comes from a disconnected layout table:

    PnL Layout =
    DATATABLE (
        "PnL Line", STRING,
        "Sort Order", INTEGER,
        {
            {"Sales", 1},
            {"Expenses", 2},
            {"Gross Profit", 3},
         
            {"Overhead", 4},
            {"Net Profit", 5}
       
        }
    )
     
    PnL Value is a measure that switches based on the selected PnL line:
    PnL Value =
    VAR Line = SELECTEDVALUE('PnL Layout'[PnL Line])
    RETURN
    SWITCH (
        Line,
        "Sales", [Total Sales],
        "Expenses", [Total Expenses],
        "Gross Profit", [Gross Profit],

        "Overhead", [Overhead],
        "Net Profit", [Net Profit]
     
    )

     

     

     

  • v-prasare's avatar
    v-prasare
    Community Support
    6 months ago

    Hi yeLc06,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

  • v-prasare's avatar
    v-prasare
    Community Support
    6 months ago

    Hi @yeLc06,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support