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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Mannai
Helper I
Helper I

Can i put measure and values in the same line chart

I want to make this line chart where the source of values highlited in yellow are from excel file and the value in the red cercle comes from a measure :

 

Mannai_0-1650622989984.png

 

Is it possible ? if yes how do i must connect the excel file to the date table 
Thank you

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

Hi @Mannai ,

Yes,you could .

Create a relationship between two tables based on date association if the data is not on one table. If on a table, create visuals directly.

Refer the below:

values is measure:

vluwangmsft_0-1651733405771.png

Outputresult:

vluwangmsft_1-1651733426589.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @Mannai ,

Yes,you could .

Create a relationship between two tables based on date association if the data is not on one table. If on a table, create visuals directly.

Refer the below:

values is measure:

vluwangmsft_0-1651733405771.png

Outputresult:

vluwangmsft_1-1651733426589.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

amitchandak
Super User
Super User

@Mannai , for that you need to have a column that gives Qtr + month Feb.  Then you add those measures and show

 

Or create a custom table and then use it( append two data )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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