Forum Discussion

Filippomonti's avatar
Filippomonti
Frequent Visitor
3 years ago
Solved

Creating matrix with data outside column

Hi all! I'm creating a report on powerBI Desktop and the output might be the one following:   Actual Actual Actual Budget Budget Budget       Business Unit SQM Revenue Unit SQM ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Filippomonti ,

     

    As far as I know, if you add separate measures like [Delta SQM]/[Delta Revenue]/[Delta Unit] in to matrix value field, matrix will expand based on Actual/Budget.

    I suggest you to try to show them in Total field in matrix. 

    Measure should look like as below.

    UnitSQM =
IF (
    HASONEVALUE ( 'TableName'[Column in Matrix Column] ),
    [UnitSQM],
    [Delta SQM]
)

    Then rename the subtotal name in visual format.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Filippomonti ,

 

As far as I know, if you add separate measures like [Delta SQM]/[Delta Revenue]/[Delta Unit] in to matrix value field, matrix will expand based on Actual/Budget.

I suggest you to try to show them in Total field in matrix. 

Measure should look like as below.

UnitSQM =
IF (
    HASONEVALUE ( 'TableName'[Column in Matrix Column] ),
    [UnitSQM],
    [Delta SQM]
)

Then rename the subtotal name in visual format.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.