What visual should I use?

[kongyuancn]

Hi All,

I have a table looks like:

Station	Test Result
Station1	Pass
Station2	Fail
Station3	Pass
Station4	Pass
Station5	Pass
Station6	Fail

I want to show it as following:

Pass	Fail	Pass
Pass	Pass	Fail

or

What visual should I use?

Thanks in advance.

[TomMartens · Accepted solution]

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

[FarhanAhmed · Accepted solution]

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.

[kongyuancn]

Thank you @FarhanAhmed @TomMartens  for your solution!

[TomMartens · Accepted solution]

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