Forum Discussion

Bajigntr's avatar
Bajigntr
New Member
2 years ago
Solved

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 =...
  • rajendraongole1's avatar
    2 years ago

    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!!