Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |