Visual with 1 column where Row Height is defined based on a metric value

[frankGB]

Hi,

I have a table with a list of events (text) that are associated with a time field and a time index. See example below.

Main Table to be visualized

Event	Time	Time Index
Event 1	06:00	1
Event 1	06:15	2
Event 1	06:30	3
Event 1	06:45	4
Event 1	07:00	5
Event 2	07:15	6
Event 2	07:30	7
Event 2	07:45	8
Event 3	08:00	9
Event 3	08:15	10
Event 3	08:30	11
Event 3	08:45	12
Event 3	09:00	13
Event 3	09:15	14
Event 3	09:30	15
Event 3	09:45	16
Event 3	10:00	17
Event 3	10:15	18
Event 3	10:30	19
Event 4	10:45	20
Event 4	11:00	21
Event 4	11:15	22
Event 5	11:30	23
Event 5	11:45	24
Event 5	12:00	25
Event 5	12:15	26
Event 6	12:30	27
Event 6	12:45	28
Event 6	13:00	29

The visualization, I am trying to accomplish basically is a single column table that scales the height of the rows based on the count of the time of time index. 

The Treemap would be one option. However, the problem with this visual is the column autoscale and that it doesn't wrap the text.  Another challenge is the sorting of the boxes in the Treemap Visual as this cannot be changed and seems to be determined automatically. 

If anbody has any idea how a visualization could be accomplished, it would be much appreciated.  

Frank

[Anonymous]

Hi @frankGB ,

As far as I know, Power BI doesn't support us to sort in Treemap. Treemap will be sorted by value in a logical order from most to least. If you add the same value like 1 into value field, Treemap will be sorted by Group field.

Here I suggest you to add [Event] and [Time Index] into group and then add a measure which return 1 into value field.

Finally, Treemap will be sorted from Event1 1 to Event6 29.

Best Regards,
Rico Zhou

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