Column chart using ending dates along the Y-axis instead of beginning dates

[mrothschild]

I have a data table that looks like the following: 

Lease start dateLease End DateResidual value

9/1/2021	8/31/2027	$1,682,174
9/1/2021	8/31/2029	$4,364,738
10/1/2021	9/30/2028	$1,000,000
10/1/2021	9/30/2028	$1,000,000
9/1/2022	8/31/2030	$3,749,198

The "Lease Start Date" column is associated with my Date table in PowerBI.  I want to create a column chart that shows the Residual Value by "Lease End Date".  Do I need to duplicate a RELATED Table and then create a new connection between Lease End Date and my Date table, or is there a way I can graph this information by Lease End Date without a RELATED?

Thanks!

[mrothschild]

Using directly instead of the Date table solved it. Thanks!

[v-janeyg-msft · Accepted solution]

Hi, @mrothschild 

Are these three columns not in the same table? Can't it be used directly?

The data you provide is not clear. In my opinion, you can directly use the fields to create a chart.

The fields of the two tables that have created the relationship can be used directly. 

Do you need to use the date in the date table? If you need to use fields in multiple tables, please provide a complete sample data so we can help you soon.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

[lbendlin]

Please read up on the DAX function USERELATIONSHIP and how to use it in your measures.