Forum Discussion
sorting a bar chart
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?
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.
6 Replies
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
pls select the right column or measure to sort.
could you pls provide the pbix file or sample data?
sry, i can't open the link you shared. what about using onedrive?
