Forum Discussion

Easley06's avatar
Easley06
Helper II
6 months ago
Solved

Matrix table

Hi, 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   sa...
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    6 months ago

    Thankyou, rohit1991, cengizhanarslan, FBergamaschi, krishnakanth240, and techies for your responses.

    Hi Easley06,

    Thankyou for the update.

    As suggested by FBergamaschi, krishnakanth240, and techies, please provide sample data that clearly demonstrates your issue or query in a structured format (not as an image) to help us understand and resolve the matter. Ensure that the data is relevant, free from any sensitive information, and directly related to the issue. Additionally, please share the expected outcome based on the given example.

    Thank you.

rohit1991's avatar
rohit1991
Super User
6 months ago

Hii Easley06 

 

In Microsoft Power BI, you can keep Region / Store / Product only at the top level and hide them for subsequent month columns by controlling visibility with ISINSCOPE() (or HASONEVALUE) inside your measures. The idea is to return BLANK for row headers when the matrix is expanded into month columns, so it visually behaves like one table.

 

Net Sales Visible :=
IF (
    ISINSCOPE ( 'Date'[Month] ),
    [Net Sales],
    BLANK ()
)