Table/Matrix display

[Anonymous]

Hello everyone I having a lot of issues to do this table/matrix without makingt a lot of things and I was wondering whether there is a better way to do so. The first table is my expected result. As you see values are orthered by % so we first get those that are above 0 and then all that are below 0. Within each of these 2 segments we got it ordered by "Δ" but the absolute of this value. What I mean by this is that if I orderes just but Δ then -1793 (the one on the top for green values) is the lowest and it would be the last one. I have these other issue that how to do a other category. All values are measures.

This is what I got so far. Drawbacks: I had to create a new mesure "positive/negative" to be able to create my positive and negative segments but dont want this column to have a name. I thought of narrow it so it would apper to be part of % but it has to have a name. Also to order Δ I could only come up with creating a new measure with absolute value ordered by this and then remove the measure.

[v-shex-msft]

Hi @Anonymous,

Can you please share the formulas and more detailed information so that we can test on it?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

@v-shex-msft  The measure are just  "sum(column)" and from them I create the other measures. Is that what you needed?

[v-shex-msft]

Hi @Anonymous,

Can you please share a pbix file with some dummy data so that we can do test on this report? You can upload it to onedrive for business and paste the link here. (notice, remove sensitive data before share)

Regards,

Xiaoxin Sheng

[lbendlin]

Disable word wrop for your column headers, then you can make the column "disappear" even when it has a name.