Matrix visual but different grouping?

[Lucian]

Hello,

I have an matrix visual that would display an "usual pivot" information: Description on rows, Year-Month on columns and two measures budget (BGT) and actual (ACT) in values:

Is it possible to have the information grouped as in the picture below?:

Kind Regards,

Lucian 

[AlexisOlson · Accepted solution]

I think you'll need a new dimension to add to the columns.

Create a new table dimType with a single Type column containing two values "BGT" and "ACT" and then a new measure that switches based on this new dimension.

SwitchMeasure =
SWITCH (
    SELECTEDVALUE ( dimType[Type] ),
    "BGT", [BGT],
    "ACT", [ACT]
)

You can use dimType[Type] in your matrix columns and this measure for the values.

[Lucian]

Hi @AlexisOlson ,

Thank you so much for your response. Indeed, it did the "trick". 👍

Kind Regards,

Lucian