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...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    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

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
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

kdaugherty's avatar
kdaugherty
Frequent Visitor
5 years ago

I created the 2 header fields but not sure what to do with them on the matrix visual, help! Thanks!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Share some data, describe the question and show the expected result.