Forum Discussion

Pacotille's avatar
Pacotille
Regular Visitor
3 years ago

Cumulative bar chart issue with legend

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,
 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Pacotille
      Regular Visitor
      3 years ago

      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