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  : ...
  • 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.

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]
 
)