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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mrothschild
Continued Contributor
Continued Contributor

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

I have a data table that looks like the following: 

 

Lease start dateLease End DateResidual value

9/1/20218/31/2027$1,682,174
9/1/20218/31/2029$4,364,738
10/1/20219/30/2028$1,000,000
10/1/20219/30/2028$1,000,000
9/1/20228/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!

 

 

 

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @mrothschild 

 

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

vjaneygmsft_0-1633487690666.png

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

View solution in original post

3 REPLIES 3
mrothschild
Continued Contributor
Continued Contributor

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

v-janeyg-msft
Community Support
Community Support

Hi, @mrothschild 

 

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

vjaneygmsft_0-1633487690666.png

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
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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