Matrix table

[yeLc06]

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.

 

[v-prasare]

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]

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

[lbendlin]

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.

[techies]

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]

)

[d_m_LNK · Accepted solution]

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.