The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
79 | |
77 | |
46 | |
39 |
User | Count |
---|---|
143 | |
113 | |
64 | |
63 | |
53 |