What visual should I use?

Hey kongyuancn ,

unfortunately there is no default and also no custom visual that allows the visualization the way you want.

This is because of the visualization does not think in linebreaks or new lines every three. Currently all the stations will be shown in one column, meaning 6 rows, or one row, meaning 6 columns.

If you can add two additional columns (row / column) to your data, that will define the position in a matrix you can use a matrix visual. So Station1 has the values row:1 and column:1, Station5 has the values row:2 and column2.

Hopefully, this provides some ideas to tackle your challenge. 

Regards,

Tom

There is no direct way to create such visualization, but as I realized your data I think there is a way around

- Create Index Column against your data (Power Query)

- Create Grouping Column this will group your data in 3 

Grouping Column = IF( MOD('Table'[Index],3) =0,3,MOD('Table'[Index],3))

-Create a Custom Column Cieling Column that will give you Row Grouping

Ceil = CEILING('Table'[Index]/3,1)

- Put Ceil in Row, Grouping Column in Column and TestResult in Values in Matrix to get following results, you can do conditional formatting and change the column header color to white to get more appropiate result.

I hope this is what you are looking for.