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.
Hi,
I have experienced this for the first time, that a column value has become 0 when the data was orgainsed in Table Visualization. However, when I see it in the Data view it gives me the correct value.
Does any one know why it happens and how can I prvent it from happening in Table
Hi @smpa01,
Can you share the pbix file please? You can delete the confidential parts first.
I tested it and found two possible types of aggregation could return 0.
Best Regards,
Dale
Hi Dale,
Many thanks for getting back to me. I tried and unfortunately could not replicate the same PBIX without deleting the confidential part.
However, by looking at your file, I realized that in the table visualisation the data was summarized. I perormed "Don't summarize" and the cells with 0 value before returned their correct value.I found this very strange though.
You mentioned about two possibilites while aggregating that could return 0. I am guessing that STDEV is one of them. My data was simply summarized and standard deviation was not performed.
Can you please share some insight on what is the other possibility when it returns 0 value.
Thank you.
Hi @smpa01,
That's very strange. I tried but can't find out any possibilities. I don't need the whole file. You can only keep the data that can show up the issue. BTW, please upgrade to the latest Desktop.
Best Regards,
Dale
I have tried to recreate the issue by keeping only the columns where it returns the 0 value. But I could not succeed.
For now, I am using"Don't Summarize" as by doing that it shows the correct value. When I apply "Sum" for some cells it turns to 0 but the sum does not take 0's into considertaion.
I am currently using the up-to-date PBI Desktop.
Thanks again.
Hi @smpa01,
I have to say I can't do anything without the file. This issue is quite weird. Two ways here:
1. Replace the confidential parts and if the issue still exists, please send me the file.
Tips: you can copy all the data in the Data view by "Copy Table".
2. File a support ticket here.
Best Regards,
Dale
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |