sorting a bar chart

[Anonymous]

Hello, I have a bar chart on X, I have the consumption which is a sum. 

I tried to sort the graph by this sum column but there are few miskates, on descending order.

How can i solve that problem? 

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

I have chosen two operations for comparison. 

In the bar chart, it actually sorts by the summary value of [Consumption TN600] in table 'airfleets_tab' (i.e. the data on the left), while after adding the legend, the data is displayed in the form on the right because of the filtering of the relationship between tables.

So please try to use the following measure and sort it.

Measure = 
CALCULATE (
    SUM ( airfleets_tab[Consumption TN600] ),
    VALUES ( fusion_qualif_airfleets[ENG_TN 600] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

https://we.tl/t-LIQO4v20Ia

[ryan_mayu]

sry, i can't open the link you shared. what about using onedrive?

[Anonymous]

yes i already choose the right columns

[ryan_mayu]

could you pls provide the pbix file or sample data?

[ryan_mayu]

@Anonymous 

pls select the right column or measure to sort.