customisable matrix view

[ArnaudLepas]

Hello,

In my report I would like to present some data in table where I define each box. My data are all in one row and I would like to make 2 visual.

Here's a simplified version of what I'd like to do

Data :

View that I would like(after a drilltrought on an equipment) :

Currently the only way I've found to do this is with cards and text box, but it doesn't give a good result:

I can't unpivot my data because I have too much calculation to do and and these calculations depend too much on the nature of the data.

[lbendlin]

I can't unpivot my data because I have too much calculation to do and and these calculations depend too much on the nature of the data.

Unpivot your data.

Then in your matrix visual you can re-purpose the column total to show the average instead.

[ArnaudLepas]

Hello,
The average is one of the reason why I can't unpivot data, because it's not a simple average, but a weighted average dependent on a parameter.

[lbendlin]

You can implement that logic in the measure for the column total.

Remember that in a matrix visual each measure is calculated four times.