Create Line Chart from a Table with multiple Date Columns

[jovani]

Hello all,

I am creating a line and clustered column chart in which has multiple columns of dates that share the same object ID (Sub-Systems) in each row.

In this case we have 2 columns of dates (soon to be 4)

-Baseline (Timeline)

-Forecast (P6 Schedule)

I created a calendar table in which has a relationship to the Baseline (Timeline) as it contains the most dates.

When creating the Reports the Forecast (P6 Schedule) is not accurate as it counts a value if there is a date, but plots it in the month of Baseline (Timeline)

Example: For August there is 8 Sub-Systems, which have the date for August 2023 in the Baseline (timeline) column. But it Counts 1 for P6 (Date) although the date is not for August. 

Even though there is no dates Pre-September on the Forecast (P6 Schedule)

How can I make the Forecast P6 line to plot for its actual dates?

Also, is there an option in which allows me to filter out a y axis line and only focus on one? So the table can show the object ID of the line when selected. As there is no values returned when focusing on Forecast P6 

[Ashish_Mathur]

Hi,

Create an inactive relationship from the Forecast column to the Date column of the Calendar Table.  Use a DAX measure pattern like this

Measure = calculate(sum(Data[Sales]),userelationship(Data[Forecast],Calendar[Date]))

[v-yueyunzh-msft · Accepted solution]

Hi,  @jovani 

Based on your requirement description, it seems you want to explore if there is an option in which allows me to filter out a y axis line and only focus on one. If you are searching for this method to achieve this in the Power BI report, I suggest you to use the "Field parameter" as the method to achieve this, you can create a "Field parameter" for the Y-Axis for the line chart and place a slicer for the Y-Axis for the line chart to dynamically select the Y-Axis you want to display for the line chart and manage  to filter out a y axis line and only focus on one

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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