Forum Discussion
Visual with 1 column where Row Height is defined based on a metric value
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
1 Reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
