The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi!
I have a time series of some values
T | Country 1 | Country 2 |
t1 | x1 | y1 |
t2 | x2 | y2 |
t3 | x3 | y3 |
t4 | x4 | y4 |
t5 | x5 | y5 |
t6 | x6 | y6 |
I have some events that ocurr in different times
T | Country 1 | Country 2 |
t2 | Measure 1 | |
t3 | Measure 2 | |
t6 | Measure 3 |
I want a graph that looks like this
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?
@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.
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
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |