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...
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: