Forum Discussion

Lucian's avatar
Lucian
Responsive Resident
4 years ago
Solved

Matrix visual but different grouping?

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 

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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.

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    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's avatar
      Lucian
      Responsive Resident
      4 years ago

      Hi AlexisOlson ,

       

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

       

      Kind Regards,

      Lucian