Forum Discussion

ktt777's avatar
ktt777
Helper V
5 years ago
Solved

Changing the column sequences in matrix

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 :...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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