cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

csv exports different values

check the image below. left is my original matrix visual. right is the exported CSV from the same visual.

the values dont match!

I have 3 levels of drilldown. I am in second level, using the second button for drilldown (2 arrows down) so I am ignoring the first level.

If I remove the first and third levels of drilldown from the matrix, the values match.

I understand this as an error on the export procedure.

 

 

csv export error.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: csv exports different values

Hi DN,

 

You can't export the second level data into .csv because it's not your data source(original table). As a workaround, you can create a calculate table using function like summarize() or others.

 

Regards,

Jimmy Tao

3 REPLIES 3
Community Support Team
Community Support Team

Re: csv exports different values

Hi DN,

 

Please check if values in table in power bi match CSV values because power bi visual will aggregate some values if other column is same.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

Re: csv exports different values

Yes, totals are correct, but not the view I need.

Below, fast example of what is happening.

 

CSV export difference.png

Community Support Team
Community Support Team

Re: csv exports different values

Hi DN,

 

You can't export the second level data into .csv because it's not your data source(original table). As a workaround, you can create a calculate table using function like summarize() or others.

 

Regards,

Jimmy Tao

Helpful resources

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.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 397 members 4,527 guests
Please welcome our newest community members: