Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

change layout in matrix

Hi!

The typical layout of data in a Matrix exhibit in Power BI is like this:

 2015 2016 2017 2018 Total 
AttributeMeasure1Measure2Measure1Measure2Measure1Measure2Measure1Measure2Measure1Measure2
A89704410032761698181344
B3757779846844628206267
C2319914072186284248161
Total149146212238150178124210635772

 

I would like it to be more like a possible format that is attainable with an Excel pivot table, like this:

 2015201620172018Total2015201620172018Total
AttributeMeasure1Measure1Measure1Measure1Measure1Measure2Measure2Measure2Measure2Measure2
A89443216181701007698344
B3777464620657988428267
C2391726224819401884161
Total149212150124635146238178210772

 

This allows you to scan along the rows for each measure to see if there is any trend with time, whereas the mixing of measure across a row in the typical matrix layout makes this more difficult.

 

Does anyone know if this is possible with a Power BI Matrix or other visualisation?

 

Many thanks for any help.

 

Mark

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    Nope, this is impossible. If column label is based on two columns, you can modify sort order in column field to change grouping order. (measures can't achieve this)

     

    Regards,

    Xiaoxin Sheng