Forum Discussion
power bi export to excel
i found the issue, and its a weird one.
Basically, i have a time dimension, which has all time periods, except the oldest period because it falls outside of the rolling 12 months.
On the page, i have a time period slicer, which uses the time dimension, and the grid uses the time dimension. When i have no time periods selected, it shows the correct total at the bottom. However, if i manually choose the oldest date, which is not in the time dimension, it filters out the oldest period. that filtered value matches the export. when no periods are selected in the slider, the individual records do not equal the total at the bottom.
So, if i dont have any time periods selected on the time slider (set it to max and min), the total at the bottom shows the full number. However, the records for the oldest period are not in the grid because its outside of the range on the time dimension.
Basically, i think the export is more correct than the grid at this point because the total on the grid is not displaying the sum of the records, its showing the total amount of all records.
I modified my slider to include all periods, including the oldest period outside of the rolling 12, and it matches exactly now.
thank you to everyone for the help
I am unsure what you mean by import mode report. can that be explained further.
I am trying to export from a data grid with like 5 columns, that is being sliced using a slicer. when i hit export, it gives me a count that is different from the subtotal at the bottom of the grid.
Community SupportHi Anonymous ,
We can check the storage mode of each data source from the field panel in the right side:
What kind of data you want to export, summarized data or underlying data? Does the exported data greater than the data in table visual or less?
Best regards,
Hi,
Thank you for the help.
The numbers in the export are lower than the numbers displayed in the power bi. I have summed the numbers in SQL, and it matches the numbers in the power bi website, but that does not match the numbers in the export.
I have also verified my data is stored as import
i found the issue, and its a weird one.
Basically, i have a time dimension, which has all time periods, except the oldest period because it falls outside of the rolling 12 months.
On the page, i have a time period slicer, which uses the time dimension, and the grid uses the time dimension. When i have no time periods selected, it shows the correct total at the bottom. However, if i manually choose the oldest date, which is not in the time dimension, it filters out the oldest period. that filtered value matches the export. when no periods are selected in the slider, the individual records do not equal the total at the bottom.
So, if i dont have any time periods selected on the time slider (set it to max and min), the total at the bottom shows the full number. However, the records for the oldest period are not in the grid because its outside of the range on the time dimension.
Basically, i think the export is more correct than the grid at this point because the total on the grid is not displaying the sum of the records, its showing the total amount of all records.
I modified my slider to include all periods, including the oldest period outside of the rolling 12, and it matches exactly now.
thank you to everyone for the help
- v-lid-msft
Hi Anonymous ,
Glad to hear that you have resolved your problem. Thank you for sharing this your research, we believe it can benefit more users. If you have any other questions about this scenario, please kindly ask here and we will try to resolve it.
Best regards,