Line and Stacked Column

[denemee123]

I have 2 table with in power BI. In first table "CASH FLOW TABLE", first column consist of name of jobs, second column is date, third column is cash flow of these jobs according to months. In second table "PROGRESS TABLE", first column consist of name of jobs, second column is date, third column is cumulative percentage progress of each jobs according to months. I try to use line and stacked column for these two table. For line values, I used cumulative percentage progress, for column values I used cash flow for each job. And for shared axis, I took date and job names from one of the table. I also manage relationship between two table. Then, I add filter visual to filter graph according to job names. But when I select one of the job, for example if I took date and job names from "CASH FLOW" table, when I filter job, only column values changes according to job, line also change but not goes cumulatively according to date, I can see only straight line which equals single value that is sum or average of progress of each job. Similarly, when I select one of the job, for example if I took date and job names from "PROGRESS" table, when I filter job, only line values changes according to job, column values also change but not according to date, I can see only single column values for each date. I want to see change of line cumulatively, and change of column values according to real values related with each date. Could you please help me? 

[Anonymous]

Hi @denemee123 ,

What is the relationship between the two tables?  One to one , one to many or many to many? What are the data like?  Could you please provide a pbix file without privacy inforamtion and desired output wiht more details. 

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

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

[denemee123]

Hi, 

I send you related screenshots about the problem. There are 2 tables, and I insert these tables to PowerBI, after some arrangement then click close&apply. First I set the relationship (you can see also in photos), then I use filter visual (to select jobs), and line & stack column visual (to show change of jobs % progress and cash flow in months accordingly). But one of them does not change when I select the job (either % progress or cash flow depending on which table I took the shared axis information).

[Anonymous]

Hi @denemee123 ,

Please change the relationship to many to many.

If I have misunderstood your meaning, please provide more details with the desired output.(Give an example)

Best Regards

Community Support Team _ Polly

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

[denemee123 · Accepted solution]

In your file there is also a problem, 

1. There should be cumulative line for progress % as in the figure what I sent you before (you can find attachment).

2. Secondly, in your also, if you look at carefully to your pbix, progress % does not change when you select the job. We can see the line only selected portion of the date (because all job dont have same start and finish when we select job now we can see unchanged line of related date period.) This is my problem actually, I have already many to many relationship, but when I click the job, either % or cash flow (one of them is) dont change. I want to see change of both values according to both date and job. But for now, both for your work and my pbix, we can see single output (average or sum or other measure for all job).