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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.