Aggregate Data and visualize them

Hi @

Based on your description, do you want to know why in power BI visualization, why sometimes the aggregation displays the data and not all the data. This is because in power bi, it is the absolute image that automatically aggregates the data from the rows that are exactly the same in the columns that are being drained. This is to facilitate a clearer view of the data structure and to prevent redundant information from affecting the view. If you want to show all the data, you need to have a column so that each row has a unique value. You can do this by adding an indexed column to the power query. And place this indexed column on the visualization.
If you get the number of rows that are not fully visualized, you can refer to the following expression:

Count Duplicate = 
VAR a = COUNTROWS('Table')
VAR b = 
SUMMARIZE(
	'Table',
	'Table'[Key],
	'Table'[Value]
)
RETURN
a - COUNTX(b,'Table'[Key])

Best regards,
Albert He

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