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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

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.

June 2025 community update carousel

Fabric Community Update - June 2025

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