Months across top as separate columns - Line Chart

[tsachse]

Does anyone know a simple way to create a line chart with billed dates on the x axis and amount billed on the y axis with each client as a separate line when the table has the month billed as separate columns across the top, as below?

Name	1/1/20	2/1/20	3/1/20
Client A	5,000	6,000	7,000
Client B	5,000	6,000	7,000
Client C	5,000	6,000	7,000

[v-juanli-msft · Accepted solution]

Hi @tsachse 

In Edit queries, select "Name" column, then "Tranform"->"Unpivot other columns",

we would have a column named "Atrribute" and another column named "Value", please rename the "Attribute" as "date", then close&&apply.

Create line charts as below

create a date table
Date table = CALENDARAUTO()

create relationships between "date table" and "table" based on [date] column

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

If you unpivot your month columns, this is trivial. Client in Legend, Month in x-axis (Axis), Value in y-axis (Values)

[tsachse]

Hi Greg, the data is not pivoted.  The raw data is in a spreadsheet maintained by our billing person who updates the amounts for each client monthly before sending out invoices.  The columns with the billing amounts run from January 2013 to the current month.  Thanks!