Forum Discussion
Filippomonti
3 years agoFrequent Visitor
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 ...
- Anonymous3 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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
3 years agoSuper User
they have to be indipendent and not redundant
Then they need to move to the left, into the Row area of your Matrix visual.