Forum Discussion
Isha_Learner
1 year agoNew Member
A Complex matrix or a complicated tabular data
Hello Community, I worked with powerBI 3 years ago. Now I have to switch back to powerBI from tableau. I am trying to create a table/matrix with multiple columns and rows which i have easily achei...
Isha_Learner
1 year agoNew Member
Hello Tahreem24
When I add my columns and rows they are going into compact form like the below screenshot.
To avoid this collapsed sheet. I tried to drill down and use tabular layout. I am still having issues. I have to expand every row to show in the data.
I have huge data and expanding each and every row is not something i can think of.
I really appreciate your help for reposnding to this issue.
Tahreem24
1 year agoSuper User
- Isha_Learner1 year agoNew Member
Hi Tahreem24
If you see the second image. I have used the drill down and only columns expanded. But My rows did not expanded.- Tahreem241 year agoSuper User
Isha_Learner I tried at my end and I can make the switch between columns and rows. If not in your case, I suggest you to close and re-open your pbix file and then check.