Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 can be shorter and still show all the data, like this:
1 4 7
2 5 8
3 6 9
Is there a way to do this in Power BI?
Solved! Go to Solution.
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:
Best Regards,
Giotto Zhi
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:
Best Regards,
Giotto Zhi
Hi,
looks fine what I would like to do. However I can't see the pictures, don't see the examples and I can't replicate.
I created the 2 header fields but not sure what to do with them on the matrix visual, help! Thanks!
Hi,
Share some data, describe the question and show the expected result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |