Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I'm trying to get two cummulative line graphs displayed within one chart, but each line has a different date source.
The first line shows the planned date vs planned data and the second line should show the actual date vs actual data. Currently, I can only get one line to accurately show the cummulative data over the time period. I think this may need screenshots to explain what I'm trying to do....
So essentially I want the dark blue line (cummulative actual data vs actual date) plotted on the same chart as the light blue line (cummulative planned data vs planned date).
From my playing around it seems the issue is the axis field, as I can get each individual graph to display correctly depending on what field I put in there.
Thanks in advance!
Solved! Go to Solution.
Hi @AlexJ01 ,
I suggest you to create a DimDate table and then build relationships between DimDate[Date] and Actual/Planned [Date].
DimDate = CALENDAR(MIN(Planned[Planned Received Date]),MAX(Planned[Planned Received Date]))
Relationship:
Measures:
Actual runnint total = CALCULATE(SUM(Acutal[Value]),FILTER(ALL('DimDate'),'DimDate'[Date]<=MAX('DimDate'[Date])))
Planned running total = CALCULATE(SUM(Planned[Value]),FILTER(ALL('DimDate'),'DimDate'[Date]<=MAX('DimDate'[Date])))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AlexJ01 ,
I suggest you to create a DimDate table and then build relationships between DimDate[Date] and Actual/Planned [Date].
DimDate = CALENDAR(MIN(Planned[Planned Received Date]),MAX(Planned[Planned Received Date]))
Relationship:
Measures:
Actual runnint total = CALCULATE(SUM(Acutal[Value]),FILTER(ALL('DimDate'),'DimDate'[Date]<=MAX('DimDate'[Date])))
Planned running total = CALCULATE(SUM(Planned[Value]),FILTER(ALL('DimDate'),'DimDate'[Date]<=MAX('DimDate'[Date])))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Rico,
Thank you for your help. The issue I have is that I get the error bellow when I try to make a relationship between the 3 date columns (ie between planned date, DimDate and Actual Date).
Is there any reason for this/or solution?
Hi @AlexJ01 ,
I think your actual data model in more complex than my sample.
The relationship in my sample is Actual[Date] —— DimDate[Date] and DimDate[Date] —— Planned[Date].
The Warning in your screenshot means that there should be active relationships as
DimDate[Date] —— Planned[Date] and Planned[Date] —— Actual[Date] in your data model. So Power BI doesn't support you to create an active relationship: Actual[Date] —— DimDate[Date]. Please check your data model. Or you can download my sample file as above and compare it with yours.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you have 2 option the scond being more of a trick:
1) create a custom visual to achevied this or see in the marketplace if someone have already done it and its avaible to general use or to buy it
2) overlap the 2 visual with the exact same axis configuration and range, them make the top visual tranparent to a certain degree that allows the second visual to be visible and that would overlap to a certain degree
Proud to be a Super User!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |