Forum Discussion

kargus's avatar
kargus
New Member
4 years ago
Solved

Chart for Hourly Data

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...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

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.