Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column Wrapping in a Visual

Let's say I have a table with the numbers 1 to 9.  It displays in a table visual like: 1 2 3 4 5 6 7 8 9   I do not want it to display like that though.  I want it to wrap so the visual ca...
  • v-gizhi-msft's avatar
    6 years ago

    Hi,

     

    According to your description, I create a table to test.

    Here is my test table:

    Please take following steps:

    1)Add an index column from 1 to 9:

    2)Create two columns:

    ColumnHeader = INT(('Table'[Index]-1)/3)+1

    RowHeader = [Index]-3*('Table'[ColumnHeader]-1)

    3)Choose matrix visual:

    4)The result shows:

    Here is my test pbix file:

    pbix  

    Best Regards,

    Giotto Zhi