Showing results for 
Search instead for 
Did you mean: 
vishy86 Regular Visitor
Regular Visitor

Data issues with exported results to excel



I had a couple of queries on the exported result/data to excel.


1. Exported result below does not have the formatting as it was done in the pbix file. 

Example - Numerical values were comma separated but the exported results below do not have the same comma separated formatting.

2. In the same screenshot below, there is an unexpected format on the Case Loss column viz. 1.3074E-12. This column was based on a calculation which is the addition of 2 other columns. All other values seem ok except for this one. Not sure why only this value apprears the way it does. Any hints or suggestions would be helpful.

Not Comma Separated.jpg


3. No delineation between multiple filters applied on exported result. (Refer below screenshot)

In the below screenshot, how to get a comma, fullstop or some segregation after 120 and before FINANCIAL_YR which is the other filter.


Multiple Filters - No Delineation.jpg

Community Support Team
Community Support Team

Re: Data issues with exported results to excel

Hi @vishy86


Data format and the actual underlying data are going to be distinct when working with that underlying data. If you need that format in Excel, you'll have to use the equivalent comma-separator feature in Excel to format the value after you export the data.You may vote this similar idea.Please check if the workaround in this post could work for you.




Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.