Changing the column sequences in matrix

[ktt777]

Hi 

i have a matrix as below .  How can i arrange the column sequences to  : Base -> Target->Q1-2021->Q2-2021? 

And No column order from 1 to 3 ascending 

Here is the link to power bi file : https://1drv.ms/u/s!ApIDnMK2eKiFgR4xe4rl5XS7WvWl?e=hNb0rb

thank you. 

[ktt777]

How can  i format the value in Q1-2021 and Q2-2021 such as being highlighted in green if it is less than target and red if it is more than target?

thanks 

[v-angzheng-msft · Accepted solution]

Hi, @ktt777 

Try to create a measure like this:

_color = 
var _r=CALCULATE([measure],FILTER('Test 2','Test 2'[Period]="Target"))
var _ifIsQ1Q2=
    IF(MAX('Test 2'[Period]) in {"Q1-2021","Q2-2021"},
    IF([measure]>_r,"red","green")
    )
return _ifIsQ1Q2

Result:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft]

Hi, @ktt777 

The sample file provided by @ryan_mayu  has already achieved the purpose very well.
Please let me describe the implementation process. You need to create a sorting column for the rows and columns in the matrix separately, and the sorting column and the row and column fields are in the same table.

In your sample I saw that you created a summary field to sort. This is a good idea, but because the summary field comes from your row field, then circular dependencies will occur here, which cannot be sorted by column.

You can manually create two sorted tables and use the RELATED function to create sorted fields in the same table.

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@ktt777 

pls see the attachment below

[amitchandak]

@ktt777 , if these are measures in values, You can move up and down. If these are column values you need a sort column and the mark that a sort column

How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c