Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Bajigntr
New Member

Matrix conditional formatting - Measures data - CSV format

Hi Team,
I'm using Matrix visual with conditional formating with rules and when i export the data into CSV format , i'm seeing the data "Measures" data too .Eg: I wrote measure like , Sales change = current - new ,so this i have given as conditional formating in matrix visual . but here when i export the data into CSV format , i'm getting the data which i wrote measures with separate column. but in excel format i don't see this extra column. only issue with CSV format. Any help is appriciated.

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @Bajigntr -Exporting data from Power BI to a CSV format, it includes all underlying data, including measures, which can lead to seeing additional columns too . 

if you want to export data in .csv then you need to add required fields only in table chart as like new, sales excluding Sales Change measure.If creating a separate table is not feasible, you might have to manually modify the CSV file post-export to remove unwanted columns.

Exporting data in CSV is a simpler format and doesn't support the rich formatting and structure that an Excel file does. As a result, complete data used to generate the visual,calculations and measures, are included in the exporting in CSV format.

Hope i have answered to your query. 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
Bajigntr
New Member

Hi rajendraongole1 , but i don't see this matter any where in Power bi documentation . with excel i'm not getting any extra columns , issue is only with CSV format . so is there anywhere written in power bi documentaion , if yes, could you please share me link 

rajendraongole1
Super User
Super User

Hi @Bajigntr -Exporting data from Power BI to a CSV format, it includes all underlying data, including measures, which can lead to seeing additional columns too . 

if you want to export data in .csv then you need to add required fields only in table chart as like new, sales excluding Sales Change measure.If creating a separate table is not feasible, you might have to manually modify the CSV file post-export to remove unwanted columns.

Exporting data in CSV is a simpler format and doesn't support the rich formatting and structure that an Excel file does. As a result, complete data used to generate the visual,calculations and measures, are included in the exporting in CSV format.

Hope i have answered to your query. 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.