The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
Was able to solve on my own by creating an index column
Was able to solve on my own by creating an index column
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.
Thanks for the quick response, I did check for that. It is set to "Don't Summarize" right now and is still showing the data like B.
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
32 |
User | Count |
---|---|
96 | |
75 | |
67 | |
52 | |
52 |