New user help with organization of data for graphing

[nblair]

I have a dataset that is based on time  ... so about 30 times an hour a take a snapshot of data in 10 different categories.

What I want to do is have the category on the Y axis and time across the X.   Although a stacked bar that just summarizes the data for the range of time is acceptable.. the ideal would be to see data change over time.

Here is a basic example of the data... I have no idea how to organize this in Power BI.

Time	Hour	Cat 1	Cat 2	Cat 3	Cat 4	Cat 5	Cat 6	Cat 7	Cat 8	Cat 9	Cat 10
Min 2	1	A	A	B	A	A	A	B	A	A	A
Min 4	1	A	A	B	B	A	A	B	B	A	A
Min 6	1	B	A	B	C	B	A	B	C	B	A
Min 8	1	A	A	B	A	A	A	B	A	A	A
Min 10	1	B	A	C	B	B	A	C	B	B	A
Min 12	1	A	A	C	B	A	A	C	B	A	A
Min 14	1	B	A	C	A	B	A	C	A	B	A
Min 2	2	A	A	B	A	A	A	B	A	A	A
Min 4	2	A	A	B	B	A	A	B	B	A	A
Min 6	2	B	A	B	C	B	A	B	C	B	A
Min 8	2	A	A	B	A	A	A	B	A	A	A
Min 10	2	B	A	C	B	B	A	C	B	B	A
Min 12	2	A	A	C	B	A	A	C	B	A	A
Min 14	2	B	A	C	A	B	A	C	A	B	A

[v-ljerr-msft]

Hi @nblair,

Have you tried Upivoting all the category columns to a "Category Type" and a "Category Value" column first, then try to show it on a Line Chart or Stacked Column Chart?

Here is an article about how to Pivot and Unpivot with Power BI for your reference.

Regards