Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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?  ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

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.