Forum Discussion

SteveWave's avatar
SteveWave
Frequent Visitor
1 year ago
Solved

Measure in axis / order does not work ..

Dear Community,

I wanted to simply use "measures in an chart axis", which works well with the DAX measure (see table 1 and 2). Unfortunately, in the final chart the "predefined order" of the measures (from table 1) is not correctly considered (see table3).

Maybe, I missed any link .. ?

Attached, please find the 3 related screen shots.

Many thanks for your help.

Best

Steve

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi SteveWave ,

     

    Thanks for DataInsights reply, that's really helpful. SteveWave Here is another method for your reference.

     

    Please switch to table view and select Measure column, then click "Sort by column" and select Order.

     

    The result of the sorting of the first four values in my test.

     

     

     

     

     

    Best regards,

    Mengmeng Li

     

2 Replies

  • SteveWave,

     

    Have you specified the sort order in the visual? Click the ellipsis on the visual and navigate to "Sort by". Also, in Table view set the "Sort by column" property of column Measure (sort by Order).

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi SteveWave ,

     

    Thanks for DataInsights reply, that's really helpful. SteveWave Here is another method for your reference.

     

    Please switch to table view and select Measure column, then click "Sort by column" and select Order.

     

    The result of the sorting of the first four values in my test.

     

     

     

     

     

    Best regards,

    Mengmeng Li