Forum Discussion
Display all data points in table or matrix
Hi PBI Gurus, I want to display all data points for products by orientation and not have it summarise the data. Below is a sample of the data table. Also below is the desired result with the orientat...
This does not work as I don't get the orientation at column level in the visual. Refer desired result.
Hi, hemann
May I ask if you have solved the problem you are experiencing?
May I ask if you have tried AllisonKennedy and Ashish_Mathur to see if their methods work? In my testing, the methods they offer work, but I don't have so much data for me to test:
New index column:
I have attached the pbix file for this small example below, I hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.