Chart for Hourly Data

[kargus]

Hello i have hourly data where each hour (1-24) of a day is stored in a separate column of the table.

How do I display this in a visual or table (example shown below) to show a total hourly by rate class (rate class is in another dimension)?  So I want to see January 4, 2020, hours 1 thru 24 and their totals by hour per rate class.  Is this possible with this table structure?

		Rate Class 1	Rate Class 2
Jan 4, 2020	Hour 1	300	150
Jan 4, 2020	Hour 2	500	600

[v-yanjiang-msft · Accepted solution]

Hi @kargus ,

According to your description, I create a sample. Here are two tables.

Here's my solution.

1.Select all hours at the same time(Ctrl +select), then click Unpivot Columns tab under the Transform ribbon.

Get the table below.

2.Create relationship between the two tables by the column Service Rate ID.

3.In the matrix visual, put Read Date and Hour Name in rows, Rate Class in columna and Value in values, get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01]

@kargus  unpivoting the data is the first step