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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
fhechene
Regular Visitor

Line graph with labels over some dates

Hi!

I have a time series of some values

TCountry 1Country 2
t1x1y1
t2x2y2
t3x3y3

t4

x4y4

t5

x5y5

t6

x6y6

 

I have some events that ocurr in different times

TCountry 1Country 2
t2Measure 1 
t3Measure 2 
t6 Measure 3

 

 

I want a graph that looks like this

Sin título.png

Every measure has a non compliance rate, which depends on the country. I'd like to add that too.

 

I've tried using different combinations of line graphs, tables and others.

Sorry if this seems to noob, but I've just started this week with Power BI.

Could anyone point me in the right direction?

 

3 REPLIES 3
amitchandak
Super User
Super User

@fhechene , Not very clear, like what is there on x-axis. If that is time and time has breaks we will not have a continuous line unless there are two or more points.  

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive 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
lbendlin
Super User
Super User

You need to unpivot your Country columns in Power Query so that you end up with a table that has these colums

 

Datetime

Country 

Value

 

Then you can use the linechart as intended.

Well, my information representation skills are not up to the task it seems, because Country is unpivoted.

My columns are

Country

Date

Value

Measure

Measure_date

 

So, I plotted dates and values for different countries. I'm only trying to put that little label with measure and measure_date

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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