Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |