Showing All Rows in Table Plot

[newpbiuser01]

Hello,

I am trying to display a data table as a table visual in Power BI, but unless there is a unique identifies (index) or unique date, Power BI automatically summarizes the table.

As as example if I have the following table (this is just a sample table and a simplified version of the data I have):

Data Table:

Product	Type	Quantity	Purchase Date	Purchase Month
Fruit	Apple	100	2020-11-05	Nov
Fruit	Apple	100	2020-11-15	Nov
Fruit	Pear	20	2020-12-01	Dec
Vegetable	Carrot	1	2020-12-05	Dec
Vegetable	Tomato	15	2020-10-01	Oct
Vegetable	Tomato	12	2020-10-02	Oct
Vegetable	Tomato	13	2020-10-03	Oct
Fruit	Banana	50	2020-09-05	Sep
Fruit	Banana	50	2020-09-15	Sep
Fruit	Banana	50	2020-10-01	Oct

I am trying to show the Product, Type, Quantity and Purchase Month as a table visual to allow a user to drilldown and extract the details, but Power BI automatically summarizes the data. Is there a way I can display the table visual without the summarization or aggregation? 

Table Visual:

Purchase Month	Product	Type	Quantity
Dec	Fruit	Pear	20
Dec	Vegetable	Carrot	1
Nov	Fruit	Apple	100
Oct	Fruit	Banana	50
Oct	Vegetable	Tomato	12
Oct	Vegetable	Tomato	13
Oct	Vegetable	Tomato	15
Sep	Fruit	Banana	50

Thank you!

[Anonymous · Accepted solution]

Hi @newpbiuser01 

If there are no separate distinct values such as Id, duplicate values will be filtered out in the table visual, so you must put a column of distinct values in the table, for example, you can create a sort column based on date, so that all values can be listed

Column = RANKX('Table',[Purchase Date],,ASC,Dense)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_]

Assuming this is the table matrix you are using, you can set it to not summarize specific fields. 

[newpbiuser01]

Hi @vicky_,

I did - I set the Quantity field to not summarize which is why the banana and apple quantity in Sept is still 50 and so is the Apple in Nov is 100.