Have a table of data, Power BI not recognizing time-series

[z3r0c00l]

Hey I've never used Power BI so guide me please.

I must be missing something, because I have a pretty simple table of data, wherein the columns are dates and each row is a different test. I want to visualize how the test data changes over time.

I've stripped down the spreadsheet to be as simple as possible, yet Im not able to get a line-chart showing all the data from all the tests.

Here's what my data looks like:

See, every row is a certain test...

Every column is a date...

And I just want to put it all in a line-chart, wherein each test is shown as a line, on its own independent axis.

When I import it I get this:

Then I drag a line-chart over to the canvas and I get this:

So, I'd appreciate any pointers.

Thanks

[audreygerred · Accepted solution]

Hello! You should have the data flattened/unpivoted so that you have a Column called Test and the values are the test name, a column that has the date, and a column that has the test results. You can unpivot in Power Query, but if new columns continue to get added to the source data, you will need to continue to update your model to account for the new column getting added in. Ideally, the source data is unpivoted, or has every column in it ahead of time (or at least as many as possible so that it limits how many times you need to manually update your model). Then you can add in a date_dim table for best practice and do your time-intelligence.

[z3r0c00l]

Alright, I think I need to pivot my data. Am I getting warmer?

[z3r0c00l]

This sub-forum alone gets at least 10 posts / hour.
That either means that Power BI is really popular or Power BI has really bad documentation...