topic Re: Matrix table in DAX Commands and Tips

Matrix table

yeLc06 — Thu, 22 Jan 2026 02:12:13 GMT

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.

Re: Matrix table

d_m_LNK — Fri, 23 Jan 2026 19:20:12 GMT

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.

Re: Matrix table

techies — Sun, 25 Jan 2026 18:27:45 GMT

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]

)

Re: Matrix table

lbendlin — Sun, 25 Jan 2026 18:48:07 GMT

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.

Re: Matrix table

v-prasare — Tue, 27 Jan 2026 12:40:50 GMT

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

Re: Matrix table

v-prasare — Fri, 30 Jan 2026 17:19:47 GMT

Hi @yeLc06,

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