Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all, is there any way we can transpose rows and columns in matrix visual. I am checking if we can expand dates as column headers instead of row headers. Image attached for reference. Thanks in advance for support.
Hi @nitinbalodi ,
What did this data referenced to the matrix originally look like? Could you please provide some example data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file.
And how did you set up your matrix (Rows:??? Columns:???? Values:???)? You may consider putting the fields that were originally placed in the Rows option into the Columns option as shown below to achieve your needs...
Best Regards
@nitinbalodi , I do not see dates in column
You can date in column of Matrix
You can use Show values on Row - To show values/measures on row
For complex display Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |