Cumulative bar chart issue with legend

[Pacotille]

Hello All,

I've been facing a problem on my data visualisation, i'm trying to make a decreasing cumulative bar chart with a legend.

Without legend, the result seems fine according to my data :

With my legend, it's going sideways :

My measure to cumulate is :

Cumulate = 

CALCULATE(

    SUM(datatest[(t)]),

    FILTER(ALLEXCEPT(datatest, datatest[classif]),

            MIN(datatest[grade_class]) <= datatest[grade_class]))

I already try to change with "ALL" but nothing good happend, any ideas ? I'm posting a link to my PBI and datasource
https://1drv.ms/f/s!AoAXhpbMPUDDhDaj0_7P0-Fc7J_g?e=cNKSRM

Thnaks in advance if anyone have an answer,

[Anonymous]

Hi @Pacotille 

After testing, when you add the legend, it cannot change the sort, so the best way is to move the legend.

Or you can add an index column in power query,then sort by the order column

You can refer to the following link.

Solved: Sort by legend on stacked bar chart - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pacotille]

Hey,
Thank you for your answer, but i'm a bit lost here. I just want to display my decreasing cumulative chart which all the [classif] in each bar. How these solutions could help me ?

I've tried the solutions in your link but nothing seems to work