Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kismet
Frequent Visitor

line chart with cumulative values & 2 data tables as input

Dear all, 

i want to create a line chart with several lines which contains cumulative values, see picture: 

one line with the actual figures ( Table Actual) and 2 other lines : cumulated budget and total budget (Table Budget).

This numbers are assigned to different products and for this line chart there is a slicer to select the product.

 

For one value that works fine: here i found this solution in different threads., e.g.

Targetkum = CALCULATE(SUM('Budget (2)'[Budget]),FILTER(ALL('Budget (2)'[Periode]),'Budget (2)'[Periode]<=MAX('Budget (2)'[Periode])))
 
But when i want to include the other cumulated value from the other table i get a line with the sum of all values (all products, all periods). What i am doing wrong ? Any ideas to get the solution as wanted ? 
 
This is how it should look at the end:
example.png
 
Kind Regards, 
kismet
 
 
 
Kind Regards, 
Magde 
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

View solution in original post

2 REPLIES 2
kismet
Frequent Visitor

Thank you for your answer. I will try to replace specific data and upload a useful example. 

If i dont reply in the next days i will close that topic. 

lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors