Forum Discussion
Display all data points in table or matrix
hemann Power BI visuals will always aggregate / summarize the values. You can get around this by adding a primary key to your table. So from your raw data table sample, in Power Query add an Index column.
Then load to Power BI.
In the model (relationships) view for Power BI, select the table the 'Product' column is in and set 'Product' as the row lable for the column, then set the 'Index' column as the key:
This will allow your products to show up without aggregation, and you'll get a new row for each line in your table:
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.
