cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vishy86 Member
Member

Data issues with exported results to excel

Hi,

 

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

1 REPLY 1
v-cherch-msft Super Contributor
Super Contributor

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.

 

Regards,

Cherie

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 492 members 4,067 guests
Please welcome our newest community members: