Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Line chart cumulative value not effect by date filter

Hi all,  Ive been learning Power Bi and Dax for the last couple of months and ive become quite stuck on a task. We have a project review dashboard with one visual that plots cummulative costs aga...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks for the reply, 

     

    I did try that but then the cumulative total seems to be caculating for the entire buisness and not just the individualy selected project. The line in yellow is the measure using ALL green line is the original measure using ALLSELECTED

     

     

     

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    It is from the Combined_All Table. I have managed to find a solution this morning. 

    I have used ALL instead of ALLSELECTED as originally suggested. Then i added an additional filter that then filteres by the selected project so im not seeing the totals for the entire company.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

It is from the Combined_All Table. I have managed to find a solution this morning. 

I have used ALL instead of ALLSELECTED as originally suggested. Then i added an additional filter that then filteres by the selected project so im not seeing the totals for the entire company.

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ，

It's glad to hear that you have gotten the solution. And thanks for sharing the solution here. Could you please mark your post as Answered? It will help the others find the solution easily if they face the same problem with yours. Thank you.

Best Regards