Forum Discussion
How to NOT Aggregate data by IDs at the row level
I have a table in which I have dates, IDs, values.
This is my expected result below in A., while what I am actually seeing is B.
How can I correct my table or change a setting to see the data as A? In my dataset the data is shown as A, meaning I literally have 2 rows for ID 1. It seems to just be how the Power BI visualization is aggregating it.
A. I want the table as these 2 rows below
ID Value Date
ID 1 .5 7/9/2019
ID 1 .5 7/9/2019
B. --Is just showing 1 row
ID Value Date
ID 1 .5 7/9/2019
3 Replies
- Cmcmahan
Resident Rockstar
In the Visualizations pane, check the ID in the values bucket. Click the drop down and make sure it's set to "Don't Summarize"
It looks like right now you're using a First summarization.
